Hello,

I have 4 employees (A,B,C,D). I have 4 toggle buttons I would like to use to filter data in my spreadsheet based on these 4 employees. I would like to, at times, Toggle Employee A-C or B-C or A-B-D or whatever combination I dream up.

Currently, I use this code to filter each employee individually,but I can't combine buttons:

Sub FilterA()

ActiveSheet.Range("$A$9:$Z$203").AutoFilter Field:=1, Criteria1:="A"

End Sub
Is this possible?

Thank you for your help!