Extract Info from Multiple files
 

I have hundreds of spread sheets that contain costing estimates. The customer
# and how much the job would cost are always located in cell D36 & J78 in any
cost sheet. I need to go into each excel file & extract the customer # & Job
cost onto a new sheet which will contain the information for all the spread
sheets. ANY SUGESTIONS WILL BE GREATLY APRECIATED.

Extract Info from Multiple files
 

You would need a macro unless you want to copy and paste

Ron De Bruin has examples here

http://www.rondebruin.nl/tips.htm


look under Copy/Paste/Merge examples


--
Regards,

Peo Sjoblom



"DP7" wrote in message
...
I have hundreds of spread sheets that contain costing estimates. The
customer
# and how much the job would cost are always located in cell D36 & J78 in
any
cost sheet. I need to go into each excel file & extract the customer # &
Job
cost onto a new sheet which will contain the information for all the
spread
sheets. ANY SUGESTIONS WILL BE GREATLY APRECIATED.