One Master File that will be cut rows and saved into numerous files

This macro, which is adapted from one I already had, should do it for you. It will not only save the sheets for you, it will leave a set of alphabetized sheets in your main workbook too, for reference.

Please Login or Register  to view this content.

This macro goes into a regular module, not a sheet module or the ThisWorkbook module.

See this earlier post of mine, it does what you want and saves to a speciied directoy. I see no reason to clutter th data book with unnecessary sheets so the data workbook remains unaltered.

Please Login or Register  to view this content.

Originally Posted by royUK

I see no reason to clutter the data book with unnecessary sheets...

A valid point.

If the reference sheets are of no value, in my macro, just change this:

Please Login or Register  to view this content.

..to this:

Please Login or Register  to view this content.

Originally Posted by JBeaucaire

A valid point.

If the reference sheets are of no value, in my macro, just change this:

Please Login or Register  to view this content.

..to this:

Please Login or Register  to view this content.

If you do this you no longer require the check for the sheet name, nor the code to move the new sheet. Whichever method though you don't need to activate the sheet

Hmm, true enough...worth a repost, I still "activate" at the top of the macro just to start from a semblance of the right spot, though that is preferentially debatable, too... anyway:

Please Login or Register  to view this content.

Go team!