circular reference or link possible ??

[BHunter]

I'd like to "link" two or more cells on different sheets so that when one is changed they all change. I'd like to be able to change any of the "linked" cells and have the rest change as well.

Example
cell A1 on sheet 1, 2 and 3 are "linked"

if sheet 1, cell A1 is changed to "hi" then cell A1 on sheets 2 and 3 will also say "hi".

If then sheet 2 cell A1 is changed from "hi" to "bye" then cell A1 on sheets 1 and 3 will also be changed from "hi" to "bye".

Is this possible? Preferably without macros, since i'm on a deadline, so no time for debugging (which usually takes me longer than writing the actual code).

Thanks

 

[mosiki]

Not possible without a macro imo.

 

[BHunter]

That's what I was afraid of. Thanks for replying.