M
Mike
I have worksheets that I would like to reference in
formulas using cells containing the worksheet names. How
do I use cell contents as the names worksheets in
formulas? For example, assume I have 12 worksheets
titled January, February, March, etc. And in a 13th
worksheet I have a column containing the values January
or February or March etc. If I want to use that column
to refer to cells in one of the 12 worksheets, how do I
use those cell contents as the worksheet name in the
actual formula? There must be some syntax that allows me
to do that.
formulas using cells containing the worksheet names. How
do I use cell contents as the names worksheets in
formulas? For example, assume I have 12 worksheets
titled January, February, March, etc. And in a 13th
worksheet I have a column containing the values January
or February or March etc. If I want to use that column
to refer to cells in one of the 12 worksheets, how do I
use those cell contents as the worksheet name in the
actual formula? There must be some syntax that allows me
to do that.