I am trying to use the excel hyperlinks to reference a specific cell on my sheet. That is easy. The problem is I want to be able to duplicate my sheet, and have those new hyperlinks reference to the new sheet (which they are on)

Say Sheet 1 has a hyperlink which points to: Sheet1!A100

Now I copy everything from Sheet 1 into Sheet 2, including the hyperlink. I want it to automatically point to: Sheet2!A100

Or in other words I want my hyperlink to somehow be written as: CurrentSheet!A100

Thanks