Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query Multiple Excel files
I give sales quotes using the same Excel worksheet but save each new one
under the person's last name. They are all saved in a folder called "Sales Quotes 2006". Is it possible to query those saved files and extract data from them, not individually but at the same time. In other words, retrive data from all the sales quotes for 2006 and then make a report in a new worksheet based on information contained in each file? --CK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Data from Multiple Excel Files | Excel Discussion (Misc queries) | |||
Excel MS Query multiple select statements | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Exporting from Excel to multiple XML files | Excel Discussion (Misc queries) | |||
Combine multiple Excel files into one master | Excel Discussion (Misc queries) |