For example, if I have 3 worksheets as follow;
• Test1
• Test2
• Test3

If the value in cell “A1” in worksheet “Test1” is 2, and cell “B1” in
worksheet “Test1” is currently linked to cell “B1” in worksheet
“Test2”.

If I change a value in cell “A1” in worksheet “Test1” from 2 to 3, I
want the link to change to “B1” but in worksheet “Test3” instead. How
to do this?

Thank you in advance.


--
nratanachai
------------------------------------------------------------------------
nratanachai's Profile: http://www.excelforum.com/member.php...o&userid=35248
View this thread: http://www.excelforum.com/showthread...hreadid=550250