Sub Test2()
Dim I As Integer, J As Integer
J = 2
With Sheets("Feuil1")
Sheets("Feuil2").Range("A1:D1").Value = .Range("A1:D1").Value
For I = 2 To .Range("A65536").End(xlUp).Row
If Range("A" & I) = "E15" Then
Sheets("Feuil2").Range("A" & J & ":D" & J).Value = .Range("A" & I & ":D" & I).Value
J = J + 1
End If
Next I
End With
End Sub