This is a simple task for anyone who is a expert ad Excel, Macros and Visual Basic for Applications
Brief: The spreadsheet will include 2 tabs, "Master" with all the data in it and "Filters" with all the column headers (which can be changed therefore those header names have to be variable).
The master tab will have an "x" amount of columns/rows. The macro will copy the whole master file into a new tab and rename the tab. However, the macro will copy the whole data after certain filters are applied so the new tab will only show the filtered data.
The new tab name should be renamed as the names in column "A" of the "Filters" tab, starting at A2 and going down to the last row of the "tab names", therefore after renaming the new tab with the name from the "tab names" column it will take all the corresponding filters and filter the master tab for it and dump that data into the new tab.
However, the most important part is that once I decide to change the filters I want to be able to type in the new filter criteria under each header in the "Filters" tab and run the macro so each tab will include the new filtered data as well as named properly. The macro should work for any spreadsheet regardless of the new data/column headers so set the headers to be variables in the master file on A1:AB1
Needed by Monday 5pm New York Time