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

 

[Dave Peterson]

=indirect("'" & $b$1 & "'!a1")

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

 

[Joerg Schaber]

Thanks! works!

=indirect("'" & $b$1 & "'!a1")