Extracting data from multiple excel files.
 

Hi, I have about 200 excel files for different companies that contain the
same financial data. Eg: sales, net income etc. The companies are classified
into 4 categories A, B C and D. I want to create a report in a new worksheet
that gets me the sales data for all the Catgory A companies etc. Please tell
me what is the best way to do this. All help is appreciated.

Thanks.

Extracting data from multiple excel files.
 

Try this page
http://www.rondebruin.nl/copy3.htm


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


"helphelp" wrote in message ...
Hi, I have about 200 excel files for different companies that contain the
same financial data. Eg: sales, net income etc. The companies are classified
into 4 categories A, B C and D. I want to create a report in a new worksheet
that gets me the sales data for all the Catgory A companies etc. Please tell
me what is the best way to do this. All help is appreciated.

Thanks.

Extracting data from multiple excel files.
 

Thanks Ron. Will try it tonight. Appreciate the help.

"Ron de Bruin" wrote:

Try this page
http://www.rondebruin.nl/copy3.htm


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


"helphelp" wrote in message ...
Hi, I have about 200 excel files for different companies that contain the
same financial data. Eg: sales, net income etc. The companies are classified
into 4 categories A, B C and D. I want to create a report in a new worksheet
that gets me the sales data for all the Catgory A companies etc. Please tell
me what is the best way to do this. All help is appreciated.

Thanks.