Dim t
Dim cell As Variant
Dim plage As Range
Sub Cherche_Combinaison()
'je ne sais pas si a1 est utilisé
a1 = Range("a1").Value
For Each cell In plage 'pour tout les cellules de la plage
If cell.Value = Range("b1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a33") 'si l une des cellules a la valeur de la variable b1 alors
If cell.Value = Range("c1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a34")
If cell.Value = Range("d1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a35")
If cell.Value = Range("e1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a36")
If cell.Value = Range("f1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a37")
If cell.Value = Range("g1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a38")
If cell.Value = Range("h1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a39")
If cell.Value = Range("i1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a40")
If cell.Value = Range("j1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a41")
If cell.Value = Range("k1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a42")
If cell.Value = Range("l1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a43")
If cell.Value = Range("m1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a44")
If cell.Value = Range("n1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a45")
If cell.Value = Range("o1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a46")
If cell.Value = Range("p1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a47")
If cell.Value = Range("q1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a48")
If cell.Value = Range("r1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a49")
If cell.Value = Range("s1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a50")
If cell.Value = Range("t1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a51")
If cell.Value = Range("u1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a52")
If cell.Value = Range("v1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a53")
If cell.Value = Range("w1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a54")
If cell.Value = Range("x1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a55")
If cell.Value = Range("y1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a56")
If cell.Value = Range("z1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a57")
If cell.Value = Range("aa1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a58")
If cell.Value = Range("ab1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a59")
If cell.Value = Range("ac1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a60")
If cell.Value = Range("ad1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a61")
If cell.Value = Range("ae1").Value Then Range(cell, cell.Offset(0, 70)).Copy Range("a62")
Next cell 'cellule suivante
End Sub
Sub LaTotale() 'ok
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Set plage = ThisWorkbook.Worksheets("Feuil3").Range("a2:a31")
t = Timer
For i = 0 To 18 ' ou 19 voir test
Call Cherche_Combinaison
Range("a1").Copy Range("ca1").Offset(0, i) 'copy cellule a1 en ca1
Range("A33:a62").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Range("A1:ae31").ClearContents
Range("A33:ae62").Copy Range("a1")
Range("A33:ae62").ClearContents
Next
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
'Call Cherche_Combinaison
MsgBox Timer - t
End Sub