ExcelBanter - How can I create a link between cells in two separate Excel sheet

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

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

- - How can I create a link between cells in two separate Excel sheet (https://www.excelbanter.com/excel-worksheet-functions/83812-how-can-i-create-link-between-cells-two-separate-excel-sheet.html)

Dawnmarie

How can I create a link between cells in two separate Excel sheet

Chip Pearson

How can I create a link between cells in two separate Excel sheet

Try something like

='Sheet2'!A1

This will return the value of cell A1 on Sheet2.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Dawnmarie" wrote in
message
...

All times are GMT +1. The time now is 02:49 PM.