Sub test_2()
Dim i&, j&, L&, Dico As Object, Rng As Range
Dim TLignes As Variant
Set Dico = CreateObject("scripting.dictionary")
With Sheets("Data") 'Nom ce la feuille à adapter
Set Rng = .Range(.Cells(1, 1), .Cells(.Rows.Count, 1).End(3)(1, 6))
TLignes = Rng
For i = LBound(TLignes, 1) To UBound(TLignes, 1)
If TLignes(i, 6) <> "" Then
Dico(TLignes(i, 6)) = ""
End If
Next i
For i = LBound(TLignes, 1) To UBound(TLignes, 1)
If Not Dico.Exists(i) Then
L = L + 1
For j = 1 To 5
TLignes(L, j) = TLignes(i, j)
Next j
End If
Next i
Rng.Clear
.Cells(1, 1).Resize(L, 5).FormulaLocal = TLignes
End With
End Sub