Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can a sheet be referenced by a value in a cell?
If I'm in sheet "Main" and the value of A1 is "DEV",
is there way to reference the DEV sheet by the value that is in a cell, in this case the value in A1? For example, in sheet "Main" A1 has "DEV", in cell A2, I do something like =Valueof(A1)!D13 I'd like to reference cell D13 in sheet "DEV", but I don't want to hard-code "DEV" or any other value in A1. Can this be done? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a master sheet referenced to multiple worksheets | Excel Discussion (Misc queries) | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
Lookup funtion referenced from another sheet. | Excel Worksheet Functions | |||
Automate a date referenced in a formula pointing to another sheet | Excel Worksheet Functions | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) |