consolidate Excel work book data

S

sagupta

Joined
Oct 2, 2005
Messages
1
Reaction score
0
I create multiple Excel workbooks to track each order I get(lots of data in each book)

I need a consolidated output sheet which moves certain pieces of data from each workbook(same location everytime) to this consolidated sheet.

Using Indirect function requires each of the files to be open(100's).

Is there a way to link each of these files into this sheet so that I can create a table in this consolidated file which moves relevant data into this file.

I don't mind typing just the name of the new file each time I create the file into this consolidated sheet.

Thanks
Sanjay
 

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

Data Consolidation 1
Formula to consolidate 130 sheets into a summary sheet 6
Consolidate Pivot Tables/Cache using Excel 2003 1
Aggregating Data in Fifteen Unopened Spreadsheets into SingleConsolidated Sheet 1
How to consolidate data from different files? 2
Consolidating multiple external pivot tables into one pivot table 1
Macros to extract data frommultiple workbooks to a master workbook 0
Data Consolidation 7

Back
Top