Sub es()
Dim x, y, a As Long, b As Long
x = Feuil2.Range("c1:h" & Feuil2.Cells(Rows.Count, 3).End(3).Row)
y = Feuil3.Range("b1:f" & Feuil3.Cells(Rows.Count, 3).End(3).Row)
For a = LBound(x) To UBound(x)
For b = LBound(y) To UBound(y)
If x(a, 1) = y(b, 2) Then x(a, 3) = y(b, 1): x(a, 4) _
= y(b, 3): x(a, 5) = y(b, 4): x(a, 6) = y(b, 5)
Next b: Next a
Feuil2.[C1].Resize(UBound(x, 1), UBound(x, 2)) = x
End Sub