how, if possible to get an hyperlink to take you to the last polulated cell in a column

[nje]

I have attached a sample file.
I would if possible like to have a hyperlink at the top of the sheet that when pressed would take you to the last populated cell in column G.
I can do a normal hyperlinks but over time the hyperlink would take you to the wrong place as the sheet is filled in more and more. Is this possible?

I have tried to adapt various macros I have found on this forum but they on't seem to do want I ask of them
I also seemed to have acquired an extra vba project (Ubitmenuo4) in the worksheet and can't get rid of it, so just ignore that

Thanks