hyperlink within sheet

hello,

i have an excel file that I need help with, attached.

in the sales sheet under the customer id, cell A2 [369700]; i want to create some kind of a hyperlink that If hit on this cell A2, it will bring me to the bottom of the sheet 369700which i can eaisly see the last sales is 19594 in [sheet 369700] CellA47. This should not limit to cellA47 as the data will continue, so the function should go to the biggest sale# in column A.



any help is appreciated.

thanks Tiger.