1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Sub MiseajourListeMarelli()
Dim FL2 As Worksheet, FL4 As Worksheet, PremAdresse As String
Dim c As Range, i As Integer, DerLig1 As Long, DerLig2 As Long
Set FL2 = Worksheets("Corr. Marelli")
Set FL4 = Worksheets("Liste générale")
DerLig1 = FL2.Cells(FL2.Rows.Count, 1).End(xlUp).Row
DerLig2 = FL4.Cells(FL4.Rows.Count, 1).End(xlUp).Row
For i = 2 To DerLig2
With FL2.Range("A2:A" & DerLig1)
Set c = .Find(What:=FL4.Cells(i, 1), LookAt:=xlWhole)
If Not c Is Nothing Then
FL4.Cells(i, 6) = c.Offset(0, 1).Value 'Mise en place de la référence Marelli
FL4.Cells(i, 7) = c.Offset(0, 3).Value 'Mise en place du Tarif Public Marelli
FL4.Cells(i, 8) = c.Offset(0, 4).Value 'Mise en place du Tarif Achat Marelli
End If
End With
Next
Set FL2 = Nothing
Set FL4 = Nothing
End Sub |
Partager