ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to link cells and when you update one it updates the other (https://www.excelbanter.com/excel-discussion-misc-queries/239988-how-link-cells-when-you-update-one-updates-other.html)

b46ygurl

How to link cells and when you update one it updates the other
 
Is it possible to link two cells (that has the same information) and when you
update one it automatically updates the other?

joel

How to link cells and when you update one it updates the other
 
No because you will create a circular reference.

"b46ygurl" wrote:

Is it possible to link two cells (that has the same information) and when you
update one it automatically updates the other?


Bob I

How to link cells and when you update one it updates the other
 
Yes the second cell contains = and the reference of the first cell.

as in A1 is the one you will update and you want C1 to equal A1 you
would put =A1 into C1.

b46ygurl wrote:

Is it possible to link two cells (that has the same information) and when you
update one it automatically updates the other?




All times are GMT +1. The time now is 05:30 PM.

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