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👍
Riny_van_Eekelen Hi, thanks for the quick response.
I think my description was a little misleading.
I use a cell at the end of a row of input cells say M22 to sum the inputs and use this to check that another part of the sheet (G26) is calculating correctly. In cell M21 I wright “Check that M22 equals cell G26”.
So I need the “M22” and “G22” reference in the text to update automatically when I add rows and/or columns to the spreadsheet.
Rocketscientist1 Same principle:
="Check that " & ADDRESS(ROW()+1,COLUMN(),4,1) & " equals " & ADDRESS(ROW()+1,COLUMN()-6,4,1)
assuming you meant to write “Check that M22 equals cell G22”
It will update when you add rows and columns before G. If that is not what you have in mind, share a workbook that shows what you are actually working on and where columns may be inserted.