Incrementing Cell References in Hyperlinks - Can't find the solution anywhere now!

[Libby.L]

Hello. I'm new to the forum, but have been searching for days on how to increment the cell reference in Hyperlinks without editing each one (of the 500)individually. I thought I found it, but now get an HTTP 404 Not Found error when I try to access it. I need to use the Add Hyperlink button (versus the formula), because I want to jump to another cell on the same worksheet. For instance, from cell K2, I need to jump to R2, K3 > R3, K4 > R4, and so on.

Can someone help?

[Bernie Deitrick]

You're being mislead about limitations of the HYPERLINK Function - just use this in K2, and copy down.

=HYPERLINK("#R" & ROW(),"Go to R" & ROW())

If you ever need to jump to a cell on another sheet, just use

=HYPERLINK("#'Sheet Name'!K" & ROW(),"Go to K" & ROW() & " on sheet ""Sheet Name""")

The # takes the place of the filename - which allows the filename to change without affecting the hyperlink. Otherwise, you can specify the filename:

=HYPERLINK("[File Name.xlsm]'Sheet Name'!K" & ROW(),"Go to K" & ROW() & " on sheet ""Sheet Name""")

[Libby.L]

Works like a dream and I'm sure I'll be using all of your suggestions!Thank you SO much! (Will mark this SOLVED as soon as I figure out how.)