Bonjour
Un essai à tester. Te convient-il ?
Option Explicit
Dim fbdd As Worksheet, tabloE, tabloB
Dim i&, iB&, j&, jB&
Sub Transfert()
Set fbdd = Sheets("BDD")
tabloE = Sheets("Extra").Range("A1").CurrentRegion
tabloB = fbdd.Range("A1").CurrentRegion
For i = 2 To UBound(tabloE, 1)
For iB = 2 To UBound(tabloB, 1)
If tabloE(i, 1) & tabloE(i, 2) = tabloB(iB, 1) & tabloB(iB, 2) Then
tabloB(iB, 4) = tabloE(i, 3)
End If
Next iB
Next i
fbdd.Range("A1").Resize(UBound(tabloB, 1), UBound(tabloB, 2)) = tabloB
fbdd.Activate
End Sub
Bye !