Sub ligne()
With Sheets(1)
For i = 1 To .Range("a65000").End(xlUp).Row
If Left(.Cells(i, 1).Value, 4) = "nom:" Then
Sheets(3).Range("a65000").End(xlUp).Offset(1, 0).Value = .Cells(i, 1).Value
Sheets(3).Range("a65000").End(xlUp).Offset(0, 1).Value = .Cells(i, 1).Offset(1, 1).Value
Sheets(3).Range("a65000").End(xlUp).Offset(0, 2).Value = .Cells(i, 1).Offset(2, 0).Value
End If
Next
End With
End Sub