Hi there freebee,
sorry, it is still very difficult to understand. If you are not able to post your complete spreadsheet (or part of it?) please post "sheet 2" (or part of it).

Why do you need to enter a hyperlink? Is it to another spreadsheet? To an internet-page? What does your hyperlink look like?

This sentence is difficult to understand: "In column ‘A’ of sheet 2 it transfers Grade numbers to match the serial number I have entered.". Can you please try to explain it more thoroughly? Where are the grade numbers transferred from? to?

The more you write and explain, the higher the chance that someone will be able to help you. Please also post your macro (if not the complete Excelfile).

Kind regards
Bjorn