Bonjour à tous,
Pas trop fignolé !
Sub SurMemeLigne()
Dim Lg%, cL%, i%, x%
Application.ScreenUpdating = False
Columns("a").Insert
Lg = Range("b65536").End(xlUp).Row
'-- tri --
Range("a3:a" & Lg) = "=d3&e3"
Range("a3:h" & Lg).Sort Key1:=Range("a3"), Order1:=xlAscending, _
Header:=xlNo, OrderCustom:=1, MatchCase:=False
'--
For i = 3 To Lg
If Cells(i + 1, "a") = Cells(i, "a") Then
x = i
Do While Cells(x + 1, "a") = Cells(x, "a")
Cells(i, 256).End(xlToLeft).Columns(2) = Cells(x + 1, "f")
Cells(i, 256).End(xlToLeft).Columns(2) = Cells(x + 1, "g")
Cells(i, 256).End(xlToLeft).Columns(2) = Cells(x + 1, "h")
Cells(x + 1, "b").Clear
x = x + 1
Loop
i = x
End If
Next i
Range("b3:b" & Lg).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Columns("a").Delete
cL = Cells.Find("*", , , , xlByRows, xlPrevious).Column
Range("e2:g2").Copy Destination:=Range(Cells(2, "h"), Cells(2, cL))
Range("1:" & cL).Columns.AutoFit
End Sub
Amicalement
Claude