Bonjour,
En attendant gmb (que je salue), tu peux regarder ce code
Sub alerte()
Dim f, i, j, l, lgn
Range("A2").CurrentRegion.Offset(1, 0).ClearContents
For Each f In Worksheets
If f.Range("L1") = "DATE ECHEANCE" Then
For i = 2 To f.Range("A" & Rows.Count).End(xlUp).Row
For j = 7 To 11
If f.Cells(i, j).Value = 1 And f.Cells(i, 12) <> "" And Date + 15 > f.Cells(i, 12) Then
lgn = Cells(Rows.Count, j - 6).End(xlUp)(2).Row
Cells(lgn, j - 6) = f.Range("A" & i) & " " & f.Range("L" & i)
Exit For
End If
Next j
Next i
End If
Next f
End Sub
A+