I'd like the following to happen. As i enter a value in cell A1, the same value should appear in cell A2. On the other hand, should i feel like entering a value in cell A2, i wish the newly provided value to appear in cell A1.
By other words, i wish to simulate that A1 and A2 in fact two displays of the same information.
I have a way of solving it but it's butt uggly and involves a bunch of coding. So, i'm looking for a SMOOTH way to solve that. (Of course, the definition of "smooth" may vary a bit but let's disregard it for now, hehe.)