Dim f, ln, lgn
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" _
Or Target.Address = "$B$7" Then
Set f = Sheets("Feuil3")
For ln = 2 To f.Range("A" & Rows.Count).End(xlUp).Row
If f.Range("B" & ln) = Me.Range("$B$10") Then 'tri pour selectionner la ref du rivet
f.Range("A" & ln & ",B" & ln & ",H" & ln & ",D" & ln).Copy 'copie des composants
lgn = Range("A" & Rows.Count).End(xlUp)(2).Row
Range("A" & lgn).PasteSpecial xlPasteValues 'coller les composants dans la page2 a partir de la cellule A dispo
End If
Next ln
End If
End Sub