Is it possible to have two input cells more or less 'alternating' so that
each cell assumes the most recent value in either cell?

An example to illustrate: the two cells start empty. A value is entered in
either of the two cells, and both cells now have that value. Aother value is
entered in either cell, and the two cells now have that value.

Ideally I'd like to avoid using VBA. Any ideas?

Henrik