ExcelBanter - Linking

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Linking (https://www.excelbanter.com/excel-programming/329044-linking.html)

Teresa

Linking

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

Tom Ogilvy

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

All times are GMT +1. The time now is 03:53 AM.