MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
cell
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
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Apr, Wed 24 - 21:17 CEST