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

Hi there,
you explanation is a little bit difficult to understand. Could you perhaps attach an example?

Best regards
Bjorn

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