Bonjour Alexkiddd, Oliv38
Essaie ceci :
Option Explicit
Sub test()
Dim a, e, dico As Object, wsName As String
Application.ScreenUpdating = False
Set dico = CreateObject("Scripting.Dictionary")
With Sheets("Feuil3")
With .Range("a1").CurrentRegion
a = .Columns(3).Offset(1).Resize(.Rows.Count - 1).Value
For Each e In a
If Not dico.exists(e) Then
dico(e) = Empty
wsName = e
If Not Evaluate("isref('" & wsName & "'!a1)") Then
Sheets.Add(after:=Sheets(Sheets.Count)).Name = wsName
End If
Sheets(wsName).Cells.Delete
.AutoFilter 3, e
.SpecialCells(xlCellTypeVisible).Copy Sheets(wsName).Cells(1)
.AutoFilter
End If
Next
End With
End With
Set dico = Nothing
Application.ScreenUpdating = True
End Sub
klin89