Your request is a common one... split one sheet of data out to separate workbooks using the values in one specific column of that primary sheet. It is NOT only 10 lines of code, so you will have to buckle down and examine one of the many turn-key solutions available on the web. Here's my published solution:
------------------------------
'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.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.
Bookmarks