1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89
| Sub Boucle()
Dim C As Long
Dim CLasseur4(100) As Integer
Dim reponse As String
Dim x As Integer
Dim i As Integer
Dim j As Integer
Dim der As Integer
Dim der2 As Integer
Dim derco2 As Integer
Dim k As Integer
Dim l As Integer
Dim doublons As String
Dim nbLignes As Integer
Dim nbLignes2 As Integer
Dim nbColonnes As Integer
doublosn = "true"
nbColonnes = 0
Dim b As Integer
Dim v As Integer
x = 1
i = 1
j = 1
l = 2
k = 2
nbLignes = Sheets("Feuil1").Range("A" & Rows.Count).End(xlUp).Row
For j = 1 To nbLignes - 1
If Sheets("Feuil1").Cells(i + 1, 1) <> Sheets("Feuil1").Cells(i, 1) Then
x = x + 1
Range(Sheets("Feuil1").Cells(i + 1, 1), Cells(i + 1, 20)).Copy Destination:=Sheets("Feuil2").Cells(x, 1)
i = i + 1
Do While Sheets("Feuil1").Cells(i + 1, 1) = Sheets("Feuil1").Cells(i, 1)
der = Sheets("feuil1").Cells(i + 1, Cells.Columns.Count).End(xlToLeft).Column - 1
der2 = Sheets("Feuil2").Cells(x, Cells.Columns.Count).End(xlToLeft).Column
For l = 2 To der + 1
k = 2
doublons = "False"
For k = 2 To der2
If Sheets("Feuil1").Cells(i + 1, l).Value = Sheets("Feuil2").Cells(x, k).Value Then
doublons = "true"
End If
Next
If doublons = "False" Then
Sheets("Feuil1").Cells(i + 1, l).Copy Destination:=Sheets("Feuil2").Cells(x, der2 + 1)
End If
Next
j = j + 1
i = i + 1
Loop
i = j + 1
End If
Next
Sheets("Feuil2").Columns(1).Copy Sheets("Feuil3").Columns(1)
nbLignes2 = Sheets("Feuil2").Range("A" & Rows.Count).End(xlUp).Row
For b = 2 To nbLignes2
nbColonnes = Sheets("Feuil2").Cells(b, 2).End(xlToRight).Column
For v = 2 To nbColonnes
Sheets("Feuil3").Cells(b, 2) = Sheets("Feuil3").Cells(b, 2) & ";" & Sheets("Feuil2").Cells(b, v)
Next
Next
For i = 2 To nbLignes2
s = Sheets("Feuil3").Cells(i, 2)
Sheets("Feuil3").Cells(i, 2) = Right(s, Len(s) - 1)
Next
End Sub |
Partager