Bonjour
Sub Répartition()
Application.ScreenUpdating = False
RAZ
With Worksheets("Feuil1")
y = .Cells(Cells.Rows.Count, 1).End(xlUp).Row
.Range("A3:D3") = "1"
.Range("A3").AutoFilter
.Range("$A$3:$D$" & y).AutoFilter Field:=1, Criteria1:=RGB(255, 0 _
, 0), Operator:=xlFilterCellColor
.Range("A4:D" & y).Copy Destination:=Worksheets("rouge").Cells(1, 1)
.Range("$A$3:$D$" & y).AutoFilter Field:=1, Criteria1:=RGB(255, _
192, 0), Operator:=xlFilterCellColor
.Range("A4:D" & y).Copy Destination:=Worksheets("orange").Cells(1, 1)
.Range("$A$3:$D$" & y).AutoFilter Field:=1, Criteria1:=RGB(255, _
192, 0), Operator:=xlFilterCellColor
.Range("A4:D" & y).Copy Destination:=Worksheets("orange").Cells(1, 1)
.Range("$A$3:$D$" & y).AutoFilter Field:=1, Criteria1:=RGB(146, _
208, 80), Operator:=xlFilterCellColor
.Range("A4:D" & y).Copy Destination:=Worksheets("vert").Cells(1, 1)
.Range("A3:D3").AutoFilter
.Range("A3:D3").ClearContents
.Activate
End With
End Sub
Sub RAZ()
Sheets(Array("orange", "vert", "rouge")).Select
Selection.Columns("A:D").ClearContents
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub