Hi folks,
I'm trying to build a script for my screenshot sample shown below. The workbook will contain 60+ worksheets listed by account numbers, and the first sheet will contain a list of all account numbers and their assigned region.
When the button is clicked all accounts listed in column A of the Account List worksheet that have matching values in column B, those worksheets are copied to a new workbook, and the new workbook is named after the region name.
So basically:
- Worksheets 3100108 and 3100109 are copied into a new workbook named "WEST".
- Worksheets 3100110, 3100200, and 3100201 are copied into a new workbook named "CENTRAL".
- Worksheets 3300000 and 3301200 are copied into a new workbook named "EAST".
The accounts (worksheet names) in column A can change so it should be based on a range.
I've got a basic VBA script for creating new workbooks based on a list, but no idea how to add in the other elements I'm looking for.
Any help is appreciated!
I'm trying to build a script for my screenshot sample shown below. The workbook will contain 60+ worksheets listed by account numbers, and the first sheet will contain a list of all account numbers and their assigned region.
When the button is clicked all accounts listed in column A of the Account List worksheet that have matching values in column B, those worksheets are copied to a new workbook, and the new workbook is named after the region name.
![R64veIe.jpg](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FR64veIe.jpg&hash=b06726d8f8a939766aabb354b8c0ec79)
So basically:
- Worksheets 3100108 and 3100109 are copied into a new workbook named "WEST".
- Worksheets 3100110, 3100200, and 3100201 are copied into a new workbook named "CENTRAL".
- Worksheets 3300000 and 3301200 are copied into a new workbook named "EAST".
The accounts (worksheet names) in column A can change so it should be based on a range.
I've got a basic VBA script for creating new workbooks based on a list, but no idea how to add in the other elements I'm looking for.
Any help is appreciated!