Mirrored cells

[Aivaras]

I have a very similar question, as it was here here.

The person in that thread asked:

Is there a way to mirror cells? Say if sometimes i want to change one cell but have another do the same then i would just put =(cell) in but if i want to sometimes edit that cell and have it change the other too, how do i do that? So they are mirrored?

In my case, i need certain cells to mirror in different sheets. For example i have a cell in sheet 1, C22 cell and i need it mirrored in sheet 2, cell C21. And there are lots of different pairs of cells that i need to "mirror" that when any of the two cells has been changed, the other mirrors the change (so the same value (text in my case) is in both cells).

I hope my problem is clear, thanks in advance for your help!

[patel45]

you can use the same way, select cell C21 on sheet2, then digit = , select sheet1, select cell C21, press Return

[Brian Drozd]

The code from the other thread will work for this as well. However, it does need to be broken up.

Let me make some assertions so I can explain. The cells to be mirrored in this example are 'Sheet1'!$A$1 and 'Sheet2'!$D$4.

In the Sheet1 macro code, you would put:

Please Login or Register  to view this content.

And in the Sheet2 macro code, you would put

Please Login or Register  to view this content.

[Aivaras]

Thanks, but i get this error - Compile Error. Sub of Function not defined.
What I am doing wrong?