BjornS,
I hope this helps you to understand what I am looking for, on sheet2 there are 44 diferent grades of various sizes from 1 to 300 runs.


when I insert a hyperlink manually in sheet 2 it does not show up on the data sheet. I can post the macros if needed.

Attached Files

spreadsheet.doc (66.0 KB, 24 views)

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