ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   link cells? (https://www.excelbanter.com/excel-programming/385593-link-cells.html)

[email protected]

link cells?
 
Is there a way to link cells on two different worksheets so that when
you edit one, the other automatically copies?


Jay

link cells?
 
Hi jdifrancesco1-

Enter a formula in one cell that refers to the other.

Select the cell on worksheet A and press =.
Then navigate to worksheet B, select the second cell, and press Enter.

That process puts a formula in the cell on worksheet A that will reflect any
change to the cell on worksheet B.

--
Jay


" wrote:

Is there a way to link cells on two different worksheets so that when
you edit one, the other automatically copies?




All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com