Forum Discussion
Solved
Auto update a cell ref with in text instruction
To help worksheets users, I write instructions in a cells at the end of relevant columns. Typically “Check that this value (i.e. the value calculated in the following cell) equals D54.” How can I m...
- Many thanks, from your response I was able to decipher the code and use in several other situations👍
Rocketscientist1 Enter this, for instance, in D55:
="Check that this value (i.e. the value calculated in the following cell) equals "& ADDRESS(ROW()-1,COLUMN(),4,1)
The instruction suggests that "the following cell" would be D56 and it should be equal to D54 (i.e. one row above but same column).
Insert rows and columns and it will keep that relationship of one row above and same column.
In case you would want to put such an instruction towards the end of each row, just change the last part of the formula to ADDRESS(ROW(),COLUMN()-1,4,1)
Many thanks, from your response I was able to decipher the code and use in several other situations👍