Excel: Can you link cells bidirectionally?
Posted on 2015-02-06
As we all know, in Excel you can enter data into one cell and then within another cell refer to that cell so that the contents of cell 1 is automatically displayed in cell 2 and cell 2 automatically updates when you modify cell 1.
Can that be set up to work both ways? I have a data field on Sheet 1 (cell 1) that I refer to in Sheet 2 (cell 2). However, not only do I want to have cell 2 automatically update when cell 1 is changed, I want cell 1 to automatically change if I modify cell 2.
I guess the behavior I am looking for would be similar to linked Word headers, where whether you change the header in Section 1 or change it in Section 2, the same contents is automatically displayed in both.
Is that possible?