Split Excel 2007 File

Hi,

I have the attached file which I would like to split up into separate files based upon the values in column A. For example I would like a code that creates 1 file with all rows for SPLAS00, another file with all data corresponding to SWOOD00 rows............. etc.

However in addition to this I would like the first row to also appear in the created files with all the headings so that everyone knows what the info is. If anyone has any existing code that they could modify to create this I'd be very grateful.

Any queries let me know.

Many Thanks

Do you want the data to be split into separate worksheets or into new workbooks?

Hi chris391
Welcome to th Forum!!
See the code in this Thread...you should be able to use it by modifying perhaps two lines of code.
http://www.excelforum.com/excel-prog...-workbook.html

Hi Chris
Try the code in the attached. Click the Button to run...let me know of issues.

Hi Chris
Glad I could help. If this satisfies your need please mark your Thread as SOLVED.