Using contents of cell to refer to a worksheet
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.
|