Extracting data from 1 file to multiple files

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste to next row if cells are not empty 2
Extract Whole Row If Q 32
Having a database issue 0
VBA - retrieve data on last create named range from previous inserted named range 0
Sub to stack data n paste unique order ID lines 3
macro to extraxt information 2
Extract data from csv file 4
Need help with merging Excel worksheets and deleting unwanted columns 3

Top