Navigation
Search
|
How Do I Reference the Changing Value Of Cell B2 When Adding a Row Above?
Sunday May 26, 2019. 09:46 PM , from MacMost
I have a spreadsheet with information in B2 that I reference in a different sheet, and add a row above the next week. I want to always reference the newest value, but the referenced cell in the summary sheet follows the original cell (now B3) and not the now new B2. Making B2 a $B$2 did not do it but gave an error message. Ideas? Thanks.
—– Julia
https://macmost.com/forum-how-do-i-reference-the-changing-value-of-cell-b2-when-adding-a-row-above.h
|
46 sources
Current Date
May, Thu 8 - 17:04 CEST
|