Hi

=INDIRECT("'" & B1 & "'!B2")


Arvi Laanemets


"tdols" wrote in message
...

Hi all,

I have a question which I can easily resolve using VBA, but are unable
to resolve via a worksheet fuction.

A huge workbook with many (similar) sheets named 'Hong Kong', 'Sidney',
'Amsterdam' etc. and one 'Totals' Sheet.

On that Totals sheet:
cell B1 = Hong Kong
cell B2 = '= Hong Kong!$B$2'

so far so good.

Now can I change B1 to Sidney and have the relative value in B2 change
to '=
Sidney!$B$2'?

I've tried many things including INDIRECT and =("="& $B$1 & "!B2") etc.
but can't get it to work.

Can this be done?

Thanks in advance.


--
tdols
------------------------------------------------------------------------
tdols's Profile:
http://www.excelforum.com/member.php...o&userid=31565
View this thread: http://www.excelforum.com/showthread...hreadid=512612