Sub deplace()
NbColonnesToMove = Cells(1, Rows("1:1").Columns.Count).End(xlToLeft).Column / 2
For i = 1 To NbColonnesToMove - 1
MaxLignesToMove = Cells(Rows.Count, 3).End(xlUp).Row 'les colonnes à déplacer seront toujours en C et D car on delete au fur et à mesure
LastLineDestination = Range("A" & Rows.Count).End(xlUp).Row + 1
Cells(1, 3).Resize(MaxLignesToMove, 2).Copy Destination:=Cells(LastLineDestination + 1, 1)
Cells(1, 3).Resize(MaxLignesToMove, 2).Delete
Next i
End Sub