How to change a link to another worksheet by changing a value in a cell?

[nratanachai]

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.

 

[Pete_UK]

You will be able to use the INDIRECT function to achieve this, but you
will need to post details of your formulae if you want some detailed
help in how to apply it to your situation.

Hope this helps.

Pete