MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
cell
Recherche

How Do I Reference the Changing Value Of Cell B2 When Adding a Row Above?

dimanche 26 mai 2019, 21:46 , par 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
Date Actuelle
jeu. 25 avril - 21:54 CEST