Linking
=indirect(A1 & "!A20")
--
Regards,
Tom Ogilvy
"teresa" wrote in message
...
In Cell A1 I have "Shell", I want to link Cell A4 to the worksheet
"Shell",
cell A20.
so that A4 = Shell!A20, instead of this Ive tried:
A4 = "A1"!A20 but this doesnt work - why not, thanks
|