Mirror Cells

**darksupernova** · 08-08-2008, 06:31 PM

Hello,

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?

Many thanks!

**davesexcel** · 08-08-2008, 07:28 PM

Originally Posted by darksupernova

Hello,

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?

Many thanks!

Hi darksupernova,
Probably not without VBA, this code would go into the worksheet module,
right click on the sheet tab and select View Code, copy and paste this code there.

Please Login or Register  to view this content.

Click me to see a sample

**darksupernova** · 08-08-2008, 08:20 PM

I tried this, but it didnt work

:

Please Login or Register  to view this content.

Any ideas?

**davesexcel** · 08-08-2008, 08:44 PM

Okay try this then

Please Login or Register  to view this content.

Please remember to wrap vba code when posting

**darksupernova** · 08-09-2008, 09:18 AM

cool thanks very much for your help!

**davesexcel** · 08-09-2008, 01:20 PM

Originally Posted by darksupernova

cool thanks very much for your help!

Did it work for you?
For me it drags for a while when activated, if it causes this problem for you, another solution will have to be found.

PS:
Just checked it out again, now seems to work fine, computer resources must have been low last night.