Super MERCIIIIIIIIIIIIIII ca fonctionne
de la même manière que la macro précédente, tu peux m'expliquer le codage ?
Merci
Private Sub CommandButton1_Click()
Set ws1 = Sheets("Liste OF")
Set ws2 = Sheets("Chemin de fer")
dlws1 = ws1.Cells(Rows.Count, 1).End(xlUp).Row + 1
dlws2 = ws2.Cells(Rows.Count, 1).End(xlUp).Row + 1
OF = ws1.Cells(2, 5)
For l = 2 To dlws1
If OF <> ws1.Cells(l, 5) Then
ws1.Range("D" & l - 1, "F" & l - 1).Copy Destination:=ws2.Range("A" & dlws2)
OF = ws1.Cells(l, 5)
dlws2 = ws2.Cells(Rows.Count, 1).End(xlUp).Row + 1
If ws2.Cells(dlws2, 5) = "" Then
ws2.Cells(dlws2, 5) = ws1.Range("B" & l)
Else
dcws2 = Cells(dlws2, Columns.Count).End(xlToLeft).Column + 1
ws2.Cells(dlws2, dcws2) = ws1.Range("B" & l)
End If
Else
If ws2.Cells(dlws2, 5) = "" Then
ws2.Cells(dlws2, 5) = ws1.Range("B" & l)
Else
dcws2 = Cells(dlws2, Columns.Count).End(xlToLeft).Column + 1
ws2.Cells(dlws2, dcws2) = ws1.Range("B" & l)
End If
End If
Next
Columns("B:X").AutoFit
End Sub