| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro: Filter Multiple header then extract to Multiple Files | Excel Discussion (Misc queries) | |||
| Extract Data from Multiple Excel Files | Excel Discussion (Misc queries) | |||
| extract non-specific info from multiple cells | Excel Discussion (Misc queries) | |||
| extract key words/data from multiple files -dump in new worksheet | New Users to Excel | |||
| Opening Multiple files and Copying the info all to one other sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
