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
| Sub CANCATENER()
Application.ScreenUpdating = False
i = Cells(Rows.Count, 12).End(xlUp).Row
For k = i To 2 Step -1
If Cells(k, 12) <> "LIB" And Cells(k, 86) = "" Then
Cells(k + 1, 14).Copy Cells(k, 86)
Rows(k + 1).Delete
End If
Next
i = Cells(Rows.Count, 12).End(xlUp).Row
For k = 2 To i Step 1
If Cells(k, 12) <> "LIB" And Cells(k + 1, 86) = "" Then
Cells(k + 2, 14).Copy Cells(k + 1, 86)
Rows(k + 2).Delete
End If
Next
i = Cells(Rows.Count, 12).End(xlUp).Row
For k = 2 To i Step 1
If Cells(k, 12) = "LIB" And Cells(k + 1, 12) = "LIB" And Cells(k, 86) = "" Then
Cells(k + 1, 14).Copy Cells(k, 86)
End If
Next
i = Cells(Rows.Count, 12).End(xlUp).Row
For k = 2 To i Step 1
If Cells(k, 86).Value = Cells(k + 1, 14).Value Then
Rows(k + 1).Delete
End If
Next
End Sub |
Partager