Extract Info from Multiple files

D

DP7

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.
 

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

Converting excel to PDF, single page converts to multiple HELP! 1
Automation of scanned file storage based on content 0
Automatically Transfer Info from one worksheet to another 1
identifying data from a separate worksheet 1
formula 2 display selected objects ONLY in new sheet from another 1
batch extract all tables from multiple word documents 1
Can a cell pull info from another cell that is on a separate workb 3
Advice on creating custom excel program 0

Top