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
| Dim I As Long
Dim J As Long
Dim Avion As String
Dim sector As String
Dim Tim As Integer
Dim Head As Integer
' balayage des lignes et comptage des avions concernés
J = 0
I = 2
Sheets("Feuil2").Cells.ClearContents
Avion = Range(Cells(I, 1), Cells(I, 1)).Value
sector = Range(Cells(I, 2), Cells(I, 2)).Value
Tim = Range(Cells(I, 3), Cells(I, 3)).Value
Head = Range(Cells(I, 4), Cells(I, 4)).Value
Do While Cells(I, 1).Value <> ""
If Cells(I, 1).Value <> Avion Then
J = J + 1
Sheets("Feuil2").Cells(J, 1).Value = Avion
Sheets("Feuil2").Cells(J, 2).Value = sector
Sheets("Feuil2").Cells(J, 3).Value = Tim
Sheets("Feuil2").Cells(J, 4).Value = Head
Avion = Cells(I, 1).Value
sector = Cells(I, 2).Value
Tim = Cells(I, 3).Value
Head = Cells(I, 4).Value
End If
I = I + 1
Loop
J = J + 1
Sheets("Feuil2").Cells(J, 1).Value = Avion
Sheets("Feuil2").Cells(J, 2).Value = sector
Sheets("Feuil2").Cells(J, 3).Value = Tim
Sheets("Feuil2").Cells(J, 4).Value = Head |
Partager