sharkmeister
New Member
- Joined
- Dec 11, 2021
- Messages
- 3
- Office Version
- 365
- 2019
- Platform
- Windows
Hi
I've searched the forum and found topics about moving sheets but my request is slightly more specific.
I'm very new to VBA and learning as I go along.
I've got a workbook with about 600 tabs. Each tab is named with a three letter code then a rep number and name e.g ABC-1-repname
I need to use a range to specify the three letter codes of which there are about 60. I then need to do the following for each code in the range:
1) Select the sheets relevant to each individual code
2) Move selected sheets to new workbook
3) Save workbook as a specific name using the 3 letter code e.g. ABC Sales November 2021
I need to do this for all 60 codes.
Anyone able to help with a solution for this please.
Thank you in advance
I've searched the forum and found topics about moving sheets but my request is slightly more specific.
I'm very new to VBA and learning as I go along.
I've got a workbook with about 600 tabs. Each tab is named with a three letter code then a rep number and name e.g ABC-1-repname
I need to use a range to specify the three letter codes of which there are about 60. I then need to do the following for each code in the range:
1) Select the sheets relevant to each individual code
2) Move selected sheets to new workbook
3) Save workbook as a specific name using the 3 letter code e.g. ABC Sales November 2021
I need to do this for all 60 codes.
Anyone able to help with a solution for this please.
Thank you in advance