Hyperlink Autofill

Hello Shribbles
Your first reference to Sheet2 is hard coded within double quotes ("") thus making it a fixed text value. Try the following:

=HYPERLINK("#"&Sheet2!B4,Sheet2!B4)

Both Sheet2 references are now cell references and should move relatively.

Hope this helps.
DBY

Thanks for the quick reply!

I tried the formula you provided. When I hit "Enter" to complete it pops up requesting to update the file. Tried letting it choose the existing file, but it returns a "#NAME?" value.