-
Checkboxes and filters
Hello Community,
I’ve been looking for some way to filter with checkboxes.
In one sheet ("category") I have several checkboxes where the .caption of each checkbox returns a value from column B of the sheet("Data") A,B,C,D.
My goal is that when I select the checkbox A a selection is displayed of all records having the . caption (or the A)Screenshot 2022-10-05 100055.jpg value of column B (or A and B if checkbox B is also checked. Style filter function for example or by displaying data (in sheet ("Category")
In addition I also have a selection in ("B1")
Most examples on the internet show me a solution with .autofilter. But are there examples (or is it possible) to use only Filter? But how.
Thank you in advance for your invaluable assistance.
Habils
-
Use a dynamic Table.
Autofilter is the best way to achieve your goal.
-
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules