HYPER LINK

[lehigh]

Hi All:

I have a workbook

The first sheet in the workbook has rows of compnay info (records,
database style, one row per company)
Each row starts out with a unique company number, but I want to make
that number a hyper-link.

I would like to click on the hyper-link and go to the second sheet and
insert the company number wich I clicked on from the first sheet. The
second sheet would then do an HLOOKUP from the first sheet.

The second sheet would be structured as form ( single sheet per
company).


Thanks for any help you can give me

Tom Snyder