I'm looking to create a macro to create 17 different files based off a template.
The macro would select the first account code from a dropdown list, run filters within tables to match rows with the selected account code (delete those that don't match)
set another dropdown list to "Jan"
saveas the sheet to have the account code in the file name,
Reset template, select the next value from the account code drop down, repeat
The macro would select the first account code from a dropdown list, run filters within tables to match rows with the selected account code (delete those that don't match)
set another dropdown list to "Jan"
saveas the sheet to have the account code in the file name,
Reset template, select the next value from the account code drop down, repeat