I am looking for a macro that splits a workbook "UNit Test.xlsx"/ This workbook has 400 sheets containing individual test scripts. I need to create new workbooks from each single worksheet from the main Workbook using the name of the sheets.
E.g
Unit Test.xlsx has sheets:
UT001, UT002, UT003 and so on to UT400
The macro needs to:
1. get the name of the first sheet
2. Move the sheet into a new workbook
3. save the new workbook using the a predefined directory path where all the new workbooks will reside.
4. go back to the main workbook (which would be having active the next sheet in the count since trhe active one was nmoved and saved into another workbook)
5. Do this till no more sheets exist.
This would create 400 sheets for me in no time instead of doing all that hard work manually.
Your help is very much appreciated.
Bookmarks