I have an Excel file that needs to be filtered. There are several categories of information that needs to be filtered at once. For example there are 56 categories each with 1 to 20 data elements to be filtered.
The macros will need to be ran on several tabs within the Excel file.
## Deliverables
I have an Excel file that needs to be filtered. There are several categories of information that needs to be filtered at once. For example there are 56 categories each with 1 to 20 data elements to be filtered.
The categories and the data elements will not change only the files will change which has several tab.
So, an ideal solution would allow me to open each new file and run a macro to filter on each set of data elements I choose. For example I want to press CTRL +A (which is one of my categories) and have it automatically filter the 20 data elements.
Another example could be that I will press CTRL+B (which is another category) and have it automatically filter on the 11 data elements.
The macros will need to be ran on several tabs within the Excel file.