Split workbook into multiple workbooks based on data

Not really getting into what your macro is doing, but I can offer a pretty much ready for primetime macro that does this, 100s of people have used it successfully after only a couple minor tweaks.


'SHEET1 TO MANY WORKBOOKS
Here's a macro for parsing rows of data from one sheet to many workbooks based on one column, workbooks named for the same values in that column.

Sheet1 to Many Workbooks

My macro names the workbooks for values in the column PLUS today's date, you can take a stab at removing the date part...or leave it in, it's a good technique.