I have a file that create a "cover page" that summarizes information based on a big database. Each "cover page" is for a different city, and I have those cities in a dropdown list (data validation style). Could someone help me -
1. Run Macro to create a new sheet for each city in the list (list is located in cell A2)
2. Rename each new sheet as the city name (located in cell A2)
screen refreshing should be off since it's a big file - that i've pulled all the data out of for the sake of simplicity
Extra special bonus
1. Could each of those newly created sheets be hardcoded once they are run?
2. Could each new hardcoded sheet for each city then be moved to a new workbook for easy saving/printing?
Thanks all - I know it's a lot, and way beyond my current skill level.
CreateNamedSheetsDropDown.xlsx
Bookmarks