I’m trying to document how my spreadsheet works. I want to tell the reader that certain information in sheet ‘A’ is obtained from a cell in sheet ‘B’. I cant give the ‘row, column’ style of address as the location of that cell might move as a result of changes to sheet ‘B’. I can’t give the address in the form B:$x$y as the address would only be updated as a result of changes in sheet B if the reference is in a formula. Can I name the target cell such that the reader can easily determine which cell it is from the name and such that Calc doesn’t insert the value in the referenced cell rather than its address?
Well, the formula
=SUBSTITUTE(CELL("ADDRESS"&T(NOW());$wasB.$E$16);"$";"")
is ugly, but it should do what you want.
You need to adapt the part $wasB when creating the formula, but later it will adapt automatically to the changes.