Hello everyone!
I want to create a very user-friendly interface on excel, which allows the user to filter a table as an automatic filter or slicer would do. In order to do it, I tried to use VBA and some macros.
I am stuck for few days now, and begin to get desperate ... That is why I am posting here!!
The working of my excel is simple:
You can find the excel file at: https://uploadfiles.io/n8e5t so you can see better what I mean.
Thank you in advance for your help!!!
I want to create a very user-friendly interface on excel, which allows the user to filter a table as an automatic filter or slicer would do. In order to do it, I tried to use VBA and some macros.
I am stuck for few days now, and begin to get desperate ... That is why I am posting here!!
The working of my excel is simple:
- The user would have the choice between a bunch of criterias, sorted according 3 categories: Actor, Ranking and Tag.
- Once he selected the criterias, he would have to click on the button 'Search'.
- By doing so, he will be directed to the spreadsheet 'Search Result' which will show him a filtered table.
You can find the excel file at: https://uploadfiles.io/n8e5t so you can see better what I mean.
Thank you in advance for your help!!!