J'ai réussi à obtenir ce que je voulais avec ce code.... si tu as des conseils en VBA pour aller plus vite , je suis preneur.
Bonne journée et encore merci.
Sub ALUELODIE()
Application.ScreenUpdating = False
i = Cells(Rows.Count, 4).End(xlUp).Row
For k = i To 4 Step -1
If Cells(k, 4) <> "LIB" And Cells(k, 6) = "" Then
Cells(k + 1, 5).Copy Cells(k, 6)
Rows(k + 1).Delete
End If
Next
i = Cells(Rows.Count, 4).End(xlUp).Row
For k = 4 To i Step 1
If Cells(k, 4) <> "LIB" And Cells(k + 1, 6) = "" Then
Cells(k + 2, 5).Copy Cells(k + 1, 6)
Rows(k + 2).Delete
End If
Next
i = Cells(Rows.Count, 4).End(xlUp).Row
For k = 4 To i Step 1
If Cells(k, 4) = "LIB" And Cells(k + 1, 4) = "LIB" And Cells(k, 6) = "" Then
Cells(k + 1, 5).Copy Cells(k, 6)
End If
Next
i = Cells(Rows.Count, 4).End(xlUp).Row
For k = 4 To i Step 1
If Cells(k, 6).Value = Cells(k + 1, 5).Value Then
Rows(k + 1).Delete
End If
Next
End Sub