J
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?
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?