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
|