cell values as worksheet reference

[Joerg Schaber]

Hi,

references to cells in a different worksheet look like this, e.g.:

='worksheet'!$A$1

In this formula I want to replace 'worksheet' by the value of a cell,
e.g. $B$1, of the current worksheet, in which stand the text
'worksheet', such that the above formula
becomes something like
=$B$1!$A$1

How does that work? The example doesn't.

thanks,

joerg

 

[Reg]

have a look at INDIRECT()

For example:

if you have 'wsname' in a2

then =indirect(A2&"!B54")

will give you the contents of wsname!B54 which I think is what you are
looking for

Regards
Reg

 

[Gary''s Student]

in cell C13 we have:
Sheet2!

In another cell:
=INDIRECT(C2 & "A1")

 

[Joerg Schaber]

Thanks! it works!

have a look at INDIRECT()

For example:

if you have 'wsname' in a2

then =indirect(A2&"!B54")

will give you the contents of wsname!B54 which I think is what you are
looking for

Regards
Reg