1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Sub recuperer()
Dim derligne As Long, i As Long, j As Long
Worksheets("Feuil2").Range("A1").Value = "Article"
Worksheets("Feuil2").Range("B1").Value = "Poids"
Worksheets("Feuil2").Range("C1").Value = "Valeur"
With Worksheets("Feuil1")
derligne = .Range("B" & Rows.Count).End(xlUp).Row
j = 2
For i = 2 To derligne
If .Cells(i, 2).Value = "Article" Then
Worksheets("Feuil2").Range("A" & j).Value = .Cells(i, 9)
Worksheets("Feuil2").Range("B" & j).Value = .Cells(i + 6, 14)
Worksheets("Feuil2").Range("C" & j).Value = .Cells(i + 6, 20)
j = j + 1
End If
Next i
End With
End Sub |