Bonjour steamby , [Zebulon] ,
un essai macro:
Sub Coincide()
Dim T1, T2, T3(), Dico1, Dico2, i As Long, x As Long, W1 As Worksheet, W2 As Worksheet, W3 As Worksheet
Set Dico1 = CreateObject("Scripting.Dictionary")
Set Dico2 = CreateObject("Scripting.Dictionary")
Set W1 = Worksheets("Feuille_01")
Set W2 = Worksheets("Feuille_02")
Set W3 = Worksheets("Feuille-Total")
T1 = W1.Range("A2:B" & W1.Range("A" & Rows.Count).End(xlUp).Row)
T2 = W2.Range("A2:B" & W2.Range("A" & Rows.Count).End(xlUp).Row)
ReDim T3(1 To UBound(T1, 1) + UBound(T2, 1), 1 To 4)
For i = LBound(T1, 1) To UBound(T1, 1)
Dico1(T1(i, 1)) = T1(i, 2)
Next
For i = LBound(T2, 1) To UBound(T2, 1)
Dico2(T2(i, 1)) = T2(i, 2)
Next
For Each clé In Dico1.keys
x = x + 1
T3(x, 1) = clé
T3(x, 2) = Dico1(clé)
If Dico2.exists(clé) Then
T3(x, 3) = clé
T3(x, 4) = Dico2(clé)
Dico2.Remove (clé)
End If
Next
For Each clé In Dico2.keys
x = x + 1
T3(x, 3) = clé
T3(x, 4) = Dico2(clé)
Next
W3.Range("A2").Resize(UBound(T3, 1), UBound(T3, 2)) = T3
End Sub
A+