INDIRECT the best choice?

[Joey L.]

Basically, I am trying to create a workbook that tracks trend data
stored in other workbooks, which are created weekly. Ideally, I'd like
to have a sheet in the new workbook where, every week, I just add the
filename of the newest weekly file, and have it reference the proper
cells in those files to update the trend data. After looking around
for a while, it looked like the Indirect function would be the answer,
but the constraint that the workbooks being referenced must be open
will become a problem as the number of weekly files I'm referencing
grows. Is there a better solution?

 

[Frank Kabel]

Hi Joey
you may have a look at the free add-in MOREFUNC.xll
(http://longre.free.fr/english). It implements the function
INDIRECT.EXT which overcomes Excel's restriction of INDIRECT
Frank