Split a worksheet into multiple files
Posted on 2013-11-08
I have a worksheet with about 15000 records organized in a table as follows;
Field1 Fiel 2 Field3 Field4 Field5 Field6
Data Name1 Data data data data
data Name1 data data data data
Data Name2 Data data data data
data Name2 data data data data
Can anyone give the VBA code to split the worksheet in multiple excel files = Number of Names.
For each Name in the Field 2 I would like to have a file. The number of records is different from one name to another. So a name can have 33 records and another name 333 records. The number of names is about 70 (I have just got the code for this).
In addition to this I would like if it is possible that the data in each newly created file to be exported and organized as a table.
Thank you very much,