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

  • Thread starter Thread starter nratanachai
  • Start date Start date
N

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.
 
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
 
Back
Top