hi, So on my spread sheet i have check boxes for colors and then when check them they will filter say red in column 2. i need help on making it so i can filter red and then if i also selected blue it will filter blue also without erasing red.
Right now this is what i'm using to filter for red when i select the red check box
ActiveSheet.Range("A2").AutoFilter Field:=3, Criteria1:="Red"
and when i select blue also it does this
ActiveSheet.Range("A2").AutoFilter Field:=3, Criteria1:="Blue"
But when i do them both it only does blue because it unfiltered Red.
Bottom line is i want to be able to filter red and blue at the same time without undoing any other filters.
(Please try and make it so i can just insert the code into each color check box such as red blue orange green etc..)
Thanks