Mirror data in two sheets
I want the data in Sheet1 and Sheet2 to mirror
each other, but only in the range of A1:C10.
So, if someone types "apple" on Sheet1 in cell A1,
I want "apple" to automatically populate cell A1
in Sheet2 (or vice versa).
How can this be achieved? (I hope this doesn't
create an infinite loop situation where data constantly
gets copied back and forth between both sheets)
|