Split Worksheets to Individual Workbooks but keep the ones with similar names, together

[Delan]

Hi
I have an Excel Macro that splits each tab within the workbook to individual workbooks and saves it to a folder. The original workbook is an extract from a reporting system in xls format.

For example, Original workbook contains tabs: London, Manchester, Sheffield, Scotland, etc.
They get split into: London.xlsx, Manchester.xlsx, Sheffield.xlsx, scotland.xlsx, etc (totally 24 workbooks)

I would like to modify this macro slightly, to do the following:

In some scenarios, the reporting system produces more than 65,536 records per tab, in such cases, the data automatically transfers to the next tab within the original spreadsheet. i.e, London, London (1), London (2) etc depending on the amount of data. Therefore when I run the macro, I would like to keep these tabs within the one workbook, and continue to the next. Would that be possible?

Also, my main workbook contains a FrontPage, which I am copying to each and every individual workbook. The macro that I use is as follows:

Please Login or Register  to view this content.

Thanks

[PCI]

Delan,
Welcome on board.
You forgot to use the code tags when posting your code, please update your thread.
Can you prepare a small sample test file to help to review the macro ...
PCI