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:
Is this possible?Sub FilterA() ActiveSheet.Range("$A$9:$Z$203").AutoFilter Field:=1, Criteria1:="A" End Sub
Thank you for your help!
Bookmarks