Private Sub Worksheet_Change(ByVal Target As Range)
Dim ligne&
If Target.Address = Range("b3").Address Then
ligne = Application.IfError(Application.Match(Range("b3"), Feuil2.Columns(1), 0), 0)
If ligne = 0 Then
Range("b8:b11").ClearContents
Else
Range("b8:b11") = Application.Transpose(Feuil2.Range("b1:e1").Offset(ligne - 1))
End If
ElseIf Not Intersect(Range("b8:b11"), Target) Is Nothing Then
ligne = Application.IfError(Application.Match(Range("b3"), Feuil2.Columns(1), 0), 0)
If Not ligne = 0 Then
Feuil2.Range("b1:e1").Offset(ligne - 1) = Application.Transpose(Range("b8:b11").Value)
End If
End If
End Sub