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
|
Sub test()
Dim i As Long
i = 2
Dim article, annee, nom, dateNaissance, zoc, typeDossier, zoneExploit As String
Dim numDossier As String
numDossier = ""
While Trim(Cells(i, 3).Value) <> ""
If (Trim(Cells(i, 3).Value) <> numDossier) Then
article = Cells(i, 1).Value
annee = Cells(i, 2).Value
numDossier = Cells(i, 3).Value
nom = Cells(i, 4).Value
dateNaissance = Cells(i, 5).Value
zoc = Cells(i, 6).Value
typeDossier = Cells(i, 7).Value
zoneExploit = Cells(i, 8).Value
End If
If (Trim(Cells(i, 1).Value) = "") Then Cells(i, 1).Value = article
If (Trim(Cells(i, 2).Value) = "") Then Cells(i, 2).Value = annee
If (Trim(Cells(i, 4).Value) = "") Then Cells(i, 4).Value = nom
If (Trim(Cells(i, 5).Value) = "") Then Cells(i, 5).Value = dateNaissance
If (Trim(Cells(i, 6).Value) = "") Then Cells(i, 6).Value = zoc
If (Trim(Cells(i, 7).Value) = "") Then Cells(i, 7).Value = typeDossier
If (Trim(Cells(i, 8).Value) = "") Then Cells(i, 8).Value = zoneExploit
i = i + 1
Wend
End Sub |
Partager