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
| Option Explicit
Sub TableauFinal()
Dim RowNo As Long, FinShRow As Long
Dim Sh As Worksheet, FinSh As Worksheet
RowNo = 2
FinShRow = 3
Set Sh = ThisWorkbook.Sheets("Base Exemple")
Set FinSh = ThisWorkbook.Sheets("Tableau final ex")
While Sh.Cells(RowNo, 1) <> ""
If Sh.Cells(RowNo, 1) <> Sh.Cells(RowNo - 1, 1) Then
FinSh.Cells(FinShRow, 1) = Sh.Cells(RowNo, 1)
FinSh.Cells(FinShRow, 2) = Sh.Cells(RowNo, 2)
FinSh.Cells(FinShRow, 3) = Sh.Cells(RowNo, 5)
FinSh.Cells(FinShRow, 4) = Format(Sh.Cells(RowNo, 7), "mm/dd/yyyy")
FinSh.Cells(FinShRow, 5) = Format(Sh.Cells(RowNo, 8), "mm/dd/yyyy")
FinSh.Cells(FinShRow, 7) = Sh.Cells(RowNo, 6)
FinShRow = FinShRow + 1
Else
End If
RowNo = RowNo + 1
Wend
Set Sh = Nothing
Set FinSh = Nothing
End Sub |
Partager