Hello,
Une propostion :
Sub Macro1()
'Feuille ALLER/RETOUR
Range("A1").CurrentRegion.AutoFilter Field:=2, Criteria1:="=Aller" _
, Operator:=xlOr, Criteria2:="=Retour"
Range("A1").CurrentRegion.Copy
Sheets.Add After:=Sheets(1)
ActiveSheet.Name = "Aller_Retour"
ActiveSheet.Paste
Application.CutCopyMode = False
'Feuille GAZ COMBUSTIBLE
Sheets(1).Range("A1").CurrentRegion.AutoFilter Field:=2, Criteria1:= _
"Gaz combustible"
Sheets(1).Range("A1").CurrentRegion.Copy
Sheets.Add After:=Sheets(1)
ActiveSheet.Name = "Gaz_combustible"
ActiveSheet.Paste
Application.CutCopyMode = False
'Feuille EAU CHAUDE
Sheets(1).Range("A1").CurrentRegion.AutoFilter Field:=2, Criteria1:= _
"Eau chaude"
Sheets(1).Range("A1").CurrentRegion.Copy
Sheets.Add After:=Sheets(1)
ActiveSheet.Name = "Eau_chaude"
ActiveSheet.Paste
Application.CutCopyMode = False
'Feuille EAU FROIDE
Sheets(1).Range("A1").CurrentRegion.AutoFilter Field:=2, Criteria1:= _
"Eau froide"
Sheets(1).Range("A1").CurrentRegion.Copy
Sheets.Add After:=Sheets(1)
ActiveSheet.Name = "Eau_froide"
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
R@g