Sub Bouton1_QuandClic()
Dim c As Range, x As Range
Dim i As Byte
For Each c In Range('a2:a5')
Set x = Range('a26:a40').Find(c)
For i = 1 To 7
Range(x.Address).Offset(0, i) = c.Offset(0, i)
Next i
Next c
End Sub