Sub Oui_pour_qui()
Application.ScreenUpdating = False
With Sheets("00")
.Activate
.Columns("A:B").Clear
.Range("G1") = "Nuit"
.Range("G2") = "Oui"
End With
Sheets("Feuil1").Columns("A:B").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("G1:G2"), CopyToRange:=Range("A1"), Unique:=True
Columns("A:B").EntireColumn.AutoFit
Range("a1").CurrentRegion.Borders.Value = 1
Range("A:A").Sort Range("A1"), xlAscending, Header:=xlYes
Application.ScreenUpdating = True
End Sub