"Linking" Cells to always have the same value

I dont think this is possible because of circular references but I figured I would ask.

Is it possible for Cell A1 on Sheet1 to always match Cell A1 on Sheet2 no matter which cell I change?

Thanks for that, however, it won't work because I need to be able to change either cell any give time. If I change A1 Sheet1 then that change needs to show up in A1 Sheet2. If I change A1 Sheet2 then that change needs to show up in A1 Sheet1.

With a macro yes. You would likely have to do 2 routines, 1 for each sheets change event in which you would:

• Check that the change was for the desired cell(s) only
• Set the other cell on the other sheet to the same value

Thanks! I got a error:

Run-time error '28':

Out of stack space