I have two sheets in my workbook.

One has a listing of table headers like:


BOBSTABLE01 - Test for Usenet Help (Cell A1, Sheet 1)


The second sheet contains the same header followed by details of the
file:


BOBSTABLE01 - Test for Usenet Help (Cell A6, Sheet 2)
FROM TO FIELD NAME
1 1 XXXXXXX
2 26 XXXXX
27 36 XXXXX
37 40 XXXXXXX
41 44 XXXXX
45 45 XXXXXXXX
46 55 XXXXXX
56 59 XXXXX
60 63 XXXXXXX


I would like to create a hyperlink from sheet one which would direct me

to the correct info on sheet two. I can do this manually but it is very

time consuming(1,590 links), is there a way to write a code that will
look for an exact match from sheet one to sheet two and hyperlink it?