VBA - Add autofilters to spreadsheet to narrow data range produced in output file
Budget: $30 – $250 USD
There are 3 files that currently work together to filter data and produce results.
"v3Updated current process.xlsm" - Initial filter file. Results are produced in cells "EN95:FA2658"
"FilterCombination.xlsx" - Indicates which filters from the "v3Updated current process.xlsm" to filter
"aapl stats.xlsx" - Results from cells "EN95:FA2658" of the "v3Updated current process.xlsm" file are pasted to this file.
Instead of pasting all of the results from "EN95:FA2658", I would like to be able to filter the results based on a secondary filter found in cells "EN4" ("TYPE"), "EO4" ("COND"), and "EP4" ("OCCUR") - total of 3 filters to be added.
These 3 filters correspond to the same columns in the "EN95:FA2658" results.
"TYPE" and "COND" filters should be dropdown menus where I can select any number of the items and items that match those that should be produced in the "aapl stats.xlsx" file.
"OCCUR" should filter based on a "MAX" and "MIN" value placed in cells EP2 AND EP3 of the "v3Updated current process.xlsm" file.
"v3Updated current process.xlsm" - Initial filter file. Results are produced in cells "EN95:FA2658"
"FilterCombination.xlsx" - Indicates which filters from the "v3Updated current process.xlsm" to filter
"aapl stats.xlsx" - Results from cells "EN95:FA2658" of the "v3Updated current process.xlsm" file are pasted to this file.
Instead of pasting all of the results from "EN95:FA2658", I would like to be able to filter the results based on a secondary filter found in cells "EN4" ("TYPE"), "EO4" ("COND"), and "EP4" ("OCCUR") - total of 3 filters to be added.
These 3 filters correspond to the same columns in the "EN95:FA2658" results.
"TYPE" and "COND" filters should be dropdown menus where I can select any number of the items and items that match those that should be produced in the "aapl stats.xlsx" file.
"OCCUR" should filter based on a "MAX" and "MIN" value placed in cells EP2 AND EP3 of the "v3Updated current process.xlsm" file.