Compile data from several workbooks

S

Space Elf

I have multiple workbooks for different projects. they are all in separate
sub folders. Within each wookbook is a worksheet I call Bug. The Bug sheet
pulls the data from that workbook which I need in a separate master workbook.

I want to pull the data from every Bug worksheet into my master workbook
without having to open each file to force it to update. I can do it cell by
cell using a direct link but that is a lot of work.

I have compiled a list of each workbook including the path. I can use that
path and get the data using =INDIRECT(ADDRESS(2,3,,,F3) where F3 is the path.
However, I have to open that file to get an update.

Is there a way to do this in Excel 2003 without having to open each file for
updates?

Thanks,

Tim
 

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

Visio to Excel 0
Cell data entering slow! 0
Use a master workbook to carry over changes to multiple workbooks 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Password protect new workbooks from template 0
Dumb question alert! What program to use? 0
Consolidation Table from Different Excel Tabs with Different Format 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0

Top