Hyperlink a cell within workbook

Hi! I am able to hyperlink a cell to another within the same workbook but when I add in additional rows or columns they hyperlink does not update. The link sends me to the same original cell. I've tried the absolute/reference solutions but still can't seem to get it. Look forward to any ideas/suggestions, even absolute/reference ones as I may have not done it properly?

Thanks for the help!

To: Maile
re:  better hyperlink

Try this version of the Hyperlink Function (borrowed from Dave McRitchie)...
  =HYPERLINK("#"&CELL("address", Sheet2!I6), Sheet2!I6)

Note:  Change the Sheet name (Sheet2!) and cell location (I6) only.
           Leave the # sign and "address" portion alone.
           The "Sheet2!I6" at the right end of the formula returns the value from that cell.
           You can change that as desired; to another cell or enter some text.

The free Excel workbook "Professional_Compare" (updated) is available at MediaFire.
(compares every cell in two worksheets Or each row in one worksheet against all rows in a second worksheet - choice of compare type)
It includes optional "Clean Data" and "Quick Uniques List" utilities.
Download (no ads) from:  http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated January 28, 2021 Views 205 Applies to: