Thank you very much! This will save me a lot of time.

"Gary''s Student" wrote:

Something like:

=HYPERLINK("#"&CELL("address",Sheet3!A72),"target is relative")

will adjust.
--
Gary''s Student - gsnu200852


"bjry" wrote:

When I hyperlink a cell and then copy paste it to another cell, the reference
still says the same. Is there a way for the cell reference to get updated
just like the formulas?

Example:
Cell A1 is hyperlink to go to A72, when I copy A1 to T1, I want the
hyperlink to go to T72 but it still goes to A72.

Thank you.