Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using worksheet names as references
I am not sure I can do this or not or if there is any easier way to do
this... any help appreciated. I have several worksheets in a workbook. To keep it simple, the worksheet names are A, B, C, D, etc. I am building a large summary table and I want to keep my formulas as simple as possible. I have entered the names of theworksheets (A, B, C, etc.) into cells A1, A2, A3, and A4, etc. I'd like to have formulas that more or less say "go to the worksheet that is referenced in cell A1, or A2, etc. Is that possible? Thanks bmac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find references to cell names | Excel Discussion (Misc queries) | |||
range names to cell references | Excel Worksheet Functions | |||
Apply names to relative references | Excel Worksheet Functions | |||
Cell References/Names | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) |