Compile data from several workbooks
in [Functions]
|
Prev: Having info in a certain cell EXACTLY same as in cell on anotherpa
Next: Returning a value if multiple conditions are met
From: Space Elf on 27 May 2010 16:24 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
From: Jacob Skaria on 27 May 2010 16:33
You can download an add-in called Morefunc which has a function called INDIRECT.EXT that will work if the source book is closed http://xcell05.free.fr/morefunc/english/index.htm -- Jacob (MVP - Excel) "Space Elf" wrote: > 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 |