Sub Bouton1_QuandClic()
Dim i As Integer
Dim c As Range
For Each c In Range('d7:d' & Range('d65536').End(xlUp).Row)
If c = 'NC' Then
With Sheets('feuil2')
derligne = .Range('d65536').End(xlUp).Row + 1
For i = 0 To 2
.Cells(derligne, i + 3) = c.Offset(0, i)
Next i
.Cells(derligne, 1) = .Cells(derligne - 1, 1) + 1
End With
End If
Next c
End Sub