link cells in different tabs where you can edit either and the other updates

[marmkid]

can you have two way links of cells?

i.e.

tab 1, cell A1 and tab 2 cell A2 are linked

when i change A1, it automatically changes A2
when i change A2, it automatically changes A1


I know how to do it one way, just wanted to know if it could work both ways

thanks!

[bebo021999]

Without VBA, it states a "circular reference".
Hope some one can help providing code.

[Logit]

This macro goes in the Sheet1 Level Module :

Please Login or Register  to view this content.

This macro goes in the Sheet2 Level Module :

Please Login or Register  to view this content.