Sub Macro1stepCleaning()
Dim x As Integer 'décalre la variable x
' Keyboard Shortcut: Ctrl+m
For x = 4 To Sheets.Count 'boucle sur tous les onglets (en partant du 4ème)
Sheets(x).Activate 'active l'onglet
Rows("1:13").Delete Shift:=xlUp
Columns("A:A").Delete Shift:=xlToLeft
Rows("2:2").Delete Shift:=xlUp
Columns("C:C").EntireColumn.AutoFit
Columns("D:F").Delete Shift:=xlToLeft
Columns("D:J").EntireColumn.AutoFit
Range("A1").CurrentRegion.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("A1:Z65000").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"AA1"), Unique:=True
ActiveWindow.LargeScroll ToRight:=0
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.ClearContents
ActiveWindow.SmallScroll ToRight:=5
Range("AA1").CurrentRegion.Cut
Range("A1").Select
ActiveSheet.Paste
Next x 'prochain onglet de la boucle
End Sub