Bonjour Narr0,
Avec un fichier se serait plus facile de travailler, mais voici un code a essayer :
Sub test()
Dim derlgn&, Nb_Client, i&, j&
Dim ws As Worksheet
Dim Tab_Result, Tab_BDD
Set ws = ActiveSheet
derlgn = ws.Range("A" & Rows.Count).End(xlUp).Row
Tab_BDD = ws.Range("A1:A" & derlgn)
Nb_Client = derlgn / 7
ReDim Tab_Result(Nb_Client - 1, 7 - 1)
With ws
For j = 0 To Nb_Client - 1
For i = 0 To UBound(Tab_Result, 1) - 1
Tab_Result(j * 7, i) = ws.Cells((j + 1) + i, 1)
Next i
Next j
.Range("B1").Resize(UBound(Tab_Result, 1), UBound(Tab_Result, 2)) = Tab_Result
End With
Set ws = Nothing
End Sub