Hi

I am trying to find a way of linking 2 cell in different worksheet together so that when the data in one changes the others mirrors it and visa versa.
eg.

When the data in Sheet1 A1:A20 changes it is mirrored in Sheet2 B10:B30
and then when data in Sheet2 B10:B30 is changed it is mirrored in Sheet1 A1:A20

Any suggestions would be very much appreciated.

Thanks