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