Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$3" Then
With Sheets("Feuil1")
rw = Application.Match(Target.Value, .Columns(2), 0)
Range("G6") = .Cells(rw, 3)
Range("G8") = .Cells(rw, 4)
Range("G10") = .Cells(rw, 5)
Range("G12") = .Cells(rw, 6)
.Rows(rw).EntireRow.Delete
End With
End If
End Sub