R
raichu.526
I have a workbook that has a list of dates in mmddyy form in a row on
a sheet (call it Batch), e.g.:
050108 050208 050508 050608 050708...
(The dates are not necessarily consecutive, nor do they follow any
mathematical formula. In actuality, I would have more than five dates,
although there would be no set number of dates.)
On another sheet (call it Tally), I summed up cells from other
workbooks whose filenames correspond with the list of dates from
Batch. These cells are referred to by their Names:
='050108.xlsm'!NameA + '050208.xlsm'!NameA + '050508.xlsm'!NameA +
'050608.xlsm'!NameA + '050708.xlsm'!NameA...
What I would like to do is come up with a macro that would automate
the summing process. In other words, start out with a reference to a
generic file name (that doesn't actually exist) like 'DATE.xlsm'!
NameA, then run a macro that would loop replacing DATE with a date
from the row in Batch, and adding up all the values in the process.
(The values referred to by NameA all reside in the same cell on a
sheet named Tally in their respective files, but since I'm using Names
with a Workbook scope that shouldn't matter...right?)
Thanks for any help that can be provided.
a sheet (call it Batch), e.g.:
050108 050208 050508 050608 050708...
(The dates are not necessarily consecutive, nor do they follow any
mathematical formula. In actuality, I would have more than five dates,
although there would be no set number of dates.)
On another sheet (call it Tally), I summed up cells from other
workbooks whose filenames correspond with the list of dates from
Batch. These cells are referred to by their Names:
='050108.xlsm'!NameA + '050208.xlsm'!NameA + '050508.xlsm'!NameA +
'050608.xlsm'!NameA + '050708.xlsm'!NameA...
What I would like to do is come up with a macro that would automate
the summing process. In other words, start out with a reference to a
generic file name (that doesn't actually exist) like 'DATE.xlsm'!
NameA, then run a macro that would loop replacing DATE with a date
from the row in Batch, and adding up all the values in the process.
(The values referred to by NameA all reside in the same cell on a
sheet named Tally in their respective files, but since I'm using Names
with a Workbook scope that shouldn't matter...right?)
Thanks for any help that can be provided.