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
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