Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I refer to cell in another worksheet in a formula | Excel Worksheet Functions | |||
Use cell contents to refer to a sheetname in a formula | Excel Worksheet Functions | |||
Refer to a worksheet/name using cell contents? | Excel Worksheet Functions | |||
how do I refer a cell to workbook name not worksheet | Excel Discussion (Misc queries) | |||
refer to last cell in worksheet? | Excel Worksheet Functions |