Transfert_V2()
Dim T, dico, dico2, i As Long, Lig As Long, Col As Integer, T1, T2, x As Integer
Set dico = CreateObject("Scripting.Dictionary")
Set dico2 = CreateObject("Scripting.Dictionary")
With Worksheets("Base")
T = .Range("A4:J" & .Range("A" & Rows.Count).End(xlUp).Row)
Dini = CDbl(.Range("A4"))
End With
For i = LBound(T, 1) To UBound(T, 1)
If Not dico2.exists(T(i, 3)) Then
x = x + 1
dico2(T(i, 3)) = x
End If
Next
For i = LBound(T, 1) To UBound(T, 1)
If T(i, 8) = "Previous" Then
clé = T(i, 3) & "|" & CDbl(T(i, 1))
dico(clé) = T(i, 5) & "|" & T(i, 10) & "|" & T(i, 9)
End If
Next
With Worksheets("Recap")
For Each clé In dico.keys
T1 = Split(clé, "|")
T2 = Split(dico(clé), "|")
'Lig = CLng(Right(T1(0), 1)) * 3
Lig = dico2(T1(0)) * 3
Col = T1(1) - Dini + 3
Cells(Lig, 1) = T1(0)
Cells(2, Col) = T1(1)
Cells(Lig, Col).Resize(UBound(T2, 1) + 1, 1) = Application.Transpose(T2)
Next
End With
End Sub