Extract Info from Multiple files

G

Guest

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

formula 2 display selected objects ONLY in new sheet from another 1
Transferring data from multiple sheets in workbook to one sheet 5
Excel Drag autofill only part of formula 3
Automatically Transfer Info from one worksheet to another 1
Can I fetch multiple rows back using VLOOKUP? 1
Need assistance with some formulas. 1
Pulling From Multiple Sheet 0
Sum a column correctly after more info is added by sorting 9

Top