Macro to Filter Data and Paste in new Workbooks

Here's my situation (and please refer me to a different thread if this has been spoken to before): I have a master list of data that I want to automatically splice and put in new workbooks. The data should be filtered on column C (Header 3 in the example). Each value when filtered in Column C needs to be included and copied over to a new worksheet, saved, closed, and repeat for the next value (in the example, there would be 5 new workbooks--Blue, Yellow, Black, Red, Orange). All columns and headers of the master list of data should be included when copying over the data. Also, if possible I want to name the .xls file as the value in Column C each time (e.g., Blue.xls). Since my data is confidential I have used some dummy data for reference. See attached.

'SHEET1 TO MANY WORKBOOKS

I have a macro that may be "ready to use" for parsing rows of data from one sheet to many workbooks named for the same values.

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.


I added it to your workbook and changed these three lines of code and it worked great

Please Login or Register  to view this content.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

You can slip in a line before the macro saves the file:

Please Login or Register  to view this content.