Option Explicit
Sub copie()
Dim f As Worksheet, f1 As Worksheet, i As Byte, j As Byte
Set f = Sheets("Feuil1")
Set f1 = Sheets("Feuil2")
j = f1.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).Row
For i = 8 To f.Cells(Rows.Count, 3).End(xlUp)
If f.Cells(i, 3) <> "" Then
f1.Cells(j, 2) = f.Cells(i, 2)
f1.Cells(j, 3) = f.Cells(i, 3)
f1.Cells(j, 4) = f.Cells(i, 4)
f1.Cells(j, 5) = f.Cells(i, 5)
j = j + 1
End If
Next i
End Sub