Sub Remplit()
Application.ScreenUpdating = False
DL = Sheets("Tarif").Range("A65500").End(xlUp).Row
T = Sheets("Tarif").Range("A2:G" & DL)
Range("C2:E65000").ClearContents: L = 2
For i = 1 To Range("A65500").End(xlUp).Row
Produit = Cells(i, "A")
For j = 1 To UBound(T)
If T(j, 2) = Produit Then
Cells(L, "C") = T(j, 1)
Cells(L, "D") = T(j, 2)
Cells(L, "E") = T(j, 3)
L = L + 1
End If
Next j
Next i
End Sub