Help with hyprelink

[freebee2]

I have a spreadsheet, when I enter a serial number in the data sheet it transfers the information I require from sheet 2.


In column ‘A’ of sheet 2 it transfers Grade numbers to match the serial number I have entered.
I want to add a hyperlink to these various grades in column ‘A’, when I do this manually it does not show up in the data sheet, is there a line of text that I can add to the macro to achieve this.

Freebee2