I am working on a report that has two worksheets. The two worksheets often
share a common number per line and I am working on linking the second sheet
to the first sheet by this common number. I have been manually adding the
hyperlinks, but each month the number of lines grows and it takes me longer
and longer to enter the hyperlinks. I am needing a macro or some way to have
excel automatically link those numbers in sheet two with the ones that match
in sheet one to save me lots of time (and possible errors).

One play using formulas ..

Illustrated in this sample from my archives:
http://savefile.com/files/1068062
Hyperlink matching name in another sht.xls

Construct:
In contact master,
Assuming names listed in A2:A10
In B2:
=IF(A2="","",IF(ISNA(MATCH(A2,'master
schedule'!A:A,0)),"",HYPERLINK("#"&CELL("address",INDIRECT("'master
schedule'!A"&MATCH(A2,'master schedule'!A:A,0))),A2)))
Copy B2 down to B10. The above creates hyperlinks in col B
which jumps to the matched name in master schedule's col A.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---
"AustinReports" wrote:
> I am working on a report that has two worksheets. The two worksheets often
> share a common number per line and I am working on linking the second sheet
> to the first sheet by this common number. I have been manually adding the
> hyperlinks, but each month the number of lines grows and it takes me longer
> and longer to enter the hyperlinks. I am needing a macro or some way to have
> excel automatically link those numbers in sheet two with the ones that match
> in sheet one to save me lots of time (and possible errors).