Salut Maxime,
quelque chose comme ça ?
Un double-clic sur la feuille 'ESABORA' démarre la macro.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'
Dim tTab
'
Cancel = True
On Error Resume Next
Application.ScreenUpdating = False
'
tTab = Range("A1:L" & Range("B" & Rows.Count).End(xlUp).Row).Value
For x = UBound(tTab, 1) To 2 Step -1
If Trim(tTab(x, 2)) = Trim(tTab(x - 1, 2)) Then
tTab(x - 1, 3) = tTab(x, 3)
tTab(x, 2) = ""
End If
Next
With Worksheets("Extract")
.Cells.Delete
.Range("A1").Resize(UBound(tTab, 1), 12).Value = tTab
.Range("B1:B" & UBound(tTab, 1)).SpecialCells(xlCellTypeBlanks).EntireRow.Delete shift:=xlUp
.Activate
End With
'
Application.ScreenUpdating = True
On Error GoTo 0
'
End Sub
A+