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

Excel 2007 - Linking workbooks 1
Consolidate Multiple Workbooks - Excel 2007 1
References to external workbooks 4
Copying Worksheets From Different Workbooks using Marco 4
links in protected workbooks 2
Macros common to several workbooks 2
copy 10 workbooks to a combined workbook 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top