Sub Occurence_Colonnne_C()
Dim mon_crt As String
Dim nb_oc As Integer
Dim i As Integer
'doublons
Application.ScreenUpdating = False
Sheets("Vue globale").Select
Columns("C:C").Copy
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = "Critères"
ActiveSheet.Paste
Application.CutCopyMode = False
Range("A1").CurrentRegion.RemoveDuplicates Columns:=1, Header:=xlYes
Range("A2").Select
nb_oc = ActiveCell.CurrentRegion.Cells.Count - 1
'boucles sur critères
For i = 1 To nb_oc
mon_crt = ActiveCell.Value
ActiveCell.Value = "=""=" & mon_crt & """"
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = mon_crt
Sheets(mon_crt).Select
Sheets("Vue globale").Columns("A:Q").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Critères").Range("A1:A2"), CopyToRange:=Range("A1") _
, Unique:=True
Sheets("Critères").Select
Selection.Delete Shift:=xlUp
Next
'suppr crt
Application.DisplayAlerts = False
Sheets("Critères").Delete
End Sub