User Profile
Rocketscientist1
Copper Contributor
Joined Oct 21, 2023
User Widgets
Recent Discussions
Re: Auto update a cell ref with in text instruction
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.835Views0likes1CommentAuto 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 make D54 written in the text update automatically when I add rows and/or columns to the worksheet.?Solved1.1KViews0likes6Comments
Recent Blog Articles
No content to show