Anonymous321
New Member
- Joined
- Oct 12, 2021
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
Hey
I'm wondering is its possible to set up a filter that filters a table by the content of a user imported cell rather than the user applying a filter by clicking the arrow and choosing an option from the dropdown box. For example in cell "b2" the user will have an option to pick a film genre, which ever they pick will filter the table in the same sheet below. Preferably I wouldn't want to use the Filter formula to to do this, but I understand that'll be the easiest option. I'm guessing VBA could be used but I'm not aware of how to accomplish this.
Any help will be appreciated, thanks.
I'm wondering is its possible to set up a filter that filters a table by the content of a user imported cell rather than the user applying a filter by clicking the arrow and choosing an option from the dropdown box. For example in cell "b2" the user will have an option to pick a film genre, which ever they pick will filter the table in the same sheet below. Preferably I wouldn't want to use the Filter formula to to do this, but I understand that'll be the easiest option. I'm guessing VBA could be used but I'm not aware of how to accomplish this.
Any help will be appreciated, thanks.