Sub validation()
Dim dlg&, n&, col&, i&, x&
Dim cel As Range
dlg = Sheets("Recap_Devis").Range("A" & Rows.Count).End(xlUp).Row + 1
With Sheets("Recap_Devis")
n = 1
.Cells(dlg, n) = Sheets("Recup devis").Range("D14")
n = 2
For i = 12 To 21
If i = 13 Then i = 14
If i = 18 Then i = 19
.Cells(dlg, n) = Sheets("Recup devis").Cells(i, "J")
n = n + 1
Next i
For i = 15 To 21
.Cells(dlg, n) = Sheets("Recup devis").Cells(i, "D")
n = n + 1
Next i
col = 2
For i = 26 To 140
For x = 1 To 7
If col = 4 Then col = 9
If col = 12 Then col = 13
.Cells(dlg, n) = Sheets("Recup devis").Cells(i, col)
col = col + 1: n = n + 1
If col > 14 Then col = 2
Next x
If i = 83 Then i = 84
Next i
For i = 141 To 144
.Cells(dlg, n) = Sheets("Recup devis").Cells(i, "L")
n=n+1
Next i
End With
End Sub