Sub Bouton3_Clic()
With Feuil1
For i = .Cells(3, 1).End(xlDown).Row To 4 Step -1
If .Cells(i, 5).Value = "lu" And .Cells(i, 6).Value = "lu" And .Cells(i, 7).Value = "lu" And CDate(.Cells(i, 3) + 30) < Date Then
ligne_vide = Feuil8.Cells(Rows.Count, 1).End(xlUp).Row
If Not Feuil8.Cells(ligne_vide, 1) = "" Then ligne_vide = ligne_vide + 1
For j = 1 To 8
Feuil8.Cells(ligne_vide, j).Value = .Cells(i, j).Value
Feuil8.Cells(ligne_vide, 9).Value = Format(Now, "dd mmmm yyyy")
Next j
.Cells(i, 1).EntireRow.Delete
End If
Next i
End With
MsgBox "terminé"
End Sub