Multiple filter, 1 Coulmn

  • 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..)


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!