Sub Commandes()
Dim cel As Range, Lg As Integer
Lg = Application.Max(14, Feuil2.Range("C" & Rows.Count).End(xlUp).Row + 1)
For Each cel In Range("E10:E" & Rows.Count).SpecialCells(xlCellTypeConstants, 1)
Feuil2.Range("C" & Lg) = cel.Offset(, -4)
Lg = Lg + 1
Next
End Sub