Public Sub Actualiser()
Dim sh1 As Worksheet, sh2 As Worksheet, dico, a, i As Long
Application.ScreenUpdating = False
Set sh1 = Feuil2: Set sh2 = Feuil2
Set dico = CreateObject("Scripting.Dictionary")
With sh1
If .FilterMode Then .ShowAllData
a = .Range("b2:b" & .Cells(Rows.Count, "b").End(xlUp).Row)
For i = LBound(a) To UBound(a): dico(a(i, 1)) = "": Next
End With
With sh2.Range("j2")
.Resize(sh2.Rows.Count - 1).ClearContents
.Resize(dico.Count) = Application.Transpose(dico.keys)
End With
End Sub