Save Multiple Worksheets as New Workbooks Based on Sheet Prefixes

I have a macro that I use to generate new workbooks based off of the existing worksheet names.

So, if a worksheet is named "10", a new workbook will be generated named "10.xlsx".

However, if I have two sheets named "10[something1]" and "10[something2]", is there a way to get both of those tabs pushed into a new workbook named "10[something]"

Essentially, the macro should be able to run through all sheets in the workbook named similary as the examples above, and perform the same save functionality.

The code that I have below is what I am currently using to perform the single worksheet to workbook save, but would really appreciate some help on performing the aforementioned:

Please Login or Register  to view this content.

Thanks in advance

Hi hamidxa

What do your Actual Sheet Names look like?

Originally Posted by jaslake

Hi hamidxa

What do your Actual Sheet Names look like?

jaslake

They would all have a 2 digit prefix followed by some name

Real examples include:
10Transition, 10Moved, 10Same
11Transition, 11Moved, 11Same
12Transition, 12Moved, 12Same
etc.

If there would be a way to save all of the 10-based prefix sheets as a workbook simply named "10.xlsx", or all of the 11-based prefix sheets as "11.xlsx", etc., then that would be perfect.

Hi hamidxa

This Code has been added to your Workbook

Please Login or Register  to view this content.

You'll need to modify this line as desired

Please Login or Register  to view this content.

The Code is called from this Procedure

Please Login or Register  to view this content.

Let me know of issues.

Hi hamidxa

I don't have the issue you describe but it's probably something in my settings.

Start from a clean Worksheet...only Master Worksheet.

Try this...if it does not work as expected there is a brute force solution...add the line of Code as indicated

Please Login or Register  to view this content.

Let me know of issues.

Hi hamidxa

Here it is (my settings). It's why I didn't have your issue. When my Platform creates New Workbooks, the New Workbook has ONLY one WorksheetSheets in New Book.jpg

You're welcome...glad I could help. Thanks for the Rep.