Hi Guys,

I'm using a For Each Loop to loop over my master workbook and save each sheets to a new workbook. This is all working fine, but what I need help with is I'd like to save two sheets where the names are similar to the new workbook.

Here is my basic code I've kindly taken off-line and adapted slightly....

Please Login or Register  to view this content.

So if my master workbook had say for example 10 worksheets... two of them had names like test1, test2 it would save both of these to the same new workbook. All the others would have separate workbooks as their names are nothing like one another,

Any help would be much appreciated.

Dave