I hope someone can help me please.

I have a worksheet (Excel 2000) where a cell (G1 on the attached screen print) is used as a data entry point for a date. In cells B27 to B463 are the dates for the period 27/10/12 to 06/01/14 (in the format "dd/mm/yy").

When I enter a date in G1 (e.g. 21/11/12) I would like to be able to click on a hyperlink (say in J1) that will automatically take me to cell B52 (the cell for 21/11/12) and so on for any date entered in G1.

In short, the hyperlink would save me the hassle of having to scroll up and down, it works out the row I want to see based upon the value entered in G1.

Thanks in advance.

Worksheet.PNG