Lucy has attended:
Excel VBA Intro Intermediate course
Fixing equations in linked sheets
When an equation in one sheet involves a cell in a second sheet, can you fix the equation so that if the value in the second sheet cell moves (e.g. when creating a new order through sorting) the equation does not pick up the new value in the old cell, but that the equation follows the original cell to wherever it moves to.
E.g. (what I want to happen is this...)
on Sheet 1, the equation in one cell is "=sheet2!G8"
on Sheet 2, the contents of cell G8 move to G5 when re-ordered
on sheet 1, the equation automatically updates to become "=sheet2!G5"
Many thanks
Lucy
RE: Fixing equations in linked sheets
Hi Lucy
Thanks for the question
I am afraid that here is no simple way to achieve your objective. I can find no method that will dynamically attract a particular value rather than a range. It might be possible to do something with VBA code, but that too would be difficult and is beyond the scope of the forum.
Regards
Stephen
