I need to be able to filter a spreadsheet received weekly from a supplier (2 weeks sample data attached on separate worksheets) by location in Column A and have that filtered data split into a separate spreadsheet for each location and saved as Location_Start Date.
For example for week 1 I would end up with 5 spreadsheets saved with the names 1305_24082021, 1306_24082021, 6589_24082021, 7256_24082021, 8423_17082021. And for week 2 there would be 5 spreadsheets named 1045_24082021, 1604_24082021, 5013_24082021, 6089_17082021, 9632_17082021.
Ultimately looking for a template that the weekly data received can be pasted into so a macro can do the filter, copy/paste & save activity for us. But any solutions would be appreciated.
Thanks
Bookmarks