Hyperlink function

[madocar]

Hi chandoo users,

I do know how to use an hyperlink excel function. The thing is when I click on B4 cell I would like to switch the view to the cell $X$7.
At least I think it should work like this.
Am I right please?

I just want to click on the cell then I want to switch the view to TODAY. Is it even possible to do this by not using macros?
Draft file in attachment.
Thank for any help,

 

[Hui]

Madocar

Use the function link this: =HYPERLINK("#$X$7","Click")

The # tells it that it is on this sheet

 

[madocar]

Hui, I can not thank you enough.
Really thanks a lot