Mirroring data in another cell
I have duplicate data in two parts of my worksheet and I want to ensure that when I change it in one cell the duplicate also changes to the same value. I'm aware of using the "equals" original cell to do this for values but not sure it works with text?
Also, this works with individual cells, is it possible to duplicate a row of cells so that changing any cell will change the corresponding cell in the duplicate row in another part of the worksheet? I hope this is understandable!
Thanks,
Barry
Macbook, Mac OS X (10.4.11)