Split an 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.
Thank you very much,