Hyperlink to a cell in the same sheet

Options

I have a project plan in progress and we have to add additional tasks as change orders which I am adding on the bottom of the sheet so that I can keep the estimated duration separate.

However I also want to keep track of these activities within the main project so that they are included in the group of activities in the project.

I am hoping that I could have a hyperlink as in Word so that the user can see the entry but on clicking on it, they are taken to the bottom of the sheet where this additional work is set out in detail.

It seems that the only hyperlinking that exists will take the user to another sheet, not the same sheet.

Thanks

Answers