I have a large data file and need to create smaller Excel files using VB.
The data file includes sales information by product for all clients, and the
new files will include all the same data, but specific to each client.

Client id is in column A. The values in this column must be used (1)
idenify all clients included in the file, (2) find the rows for each client,
and (3) create a new file that only includes the rows that were found. The
name of each new file will be SALES{client id}.xls.

For Example:
If the value in client id = 'ABC', extract data to the file named SALES_ABC;
If the value in client id = 'DEF', extract data to the file named SALES_DEF;
etc.

Hi Brian

See
http://www.rondebruin.nl/copy5.htm

Test this one
http://www.rondebruin.nl/copy5.htm#workbook


--
Regards Ron De Bruin
http://www.rondebruin.nl



"Brian C" wrote in message ...
I have a large data file and need to create smaller Excel files using VB.
The data file includes sales information by product for all clients, and the
new files will include all the same data, but specific to each client.

Client id is in column A. The values in this column must be used (1)
idenify all clients included in the file, (2) find the rows for each client,
and (3) create a new file that only includes the rows that were found. The
name of each new file will be SALES{client id}.xls.

For Example:
If the value in client id = 'ABC', extract data to the file named SALES_ABC;
If the value in client id = 'DEF', extract data to the file named SALES_DEF;
etc.