ExcelBanter - linking cells

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - linking cells (https://www.excelbanter.com/excel-worksheet-functions/71142-linking-cells.html)

Biovin

linking cells

How can I have link two cells from different woksheets?

tony h

linking cells

try
=[Book2]Sheet3!$A$10
or
=Sheet3!A10

as appropriate

regards

--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=511497

All times are GMT +1. The time now is 01:48 PM.