Use the =HYPERLINK() function:

=HYPERLINK("#Sheet3!I14",Sheet3!I14)

So the value of the destination will be displayed as well as a link to it.

By the way this link is both "clickable" and can be used as a number.
--
Gary''s Student - gsnu200767


"micksa" wrote:

I need to create hyperlinks from info in one tab of a workbook to a matching
cell on another tab containing more data.

Data on tab 1 will stay in the same row but is a numerical value and will
change daily. Data i want to link to in tab 2 is also a numerical value. I
need to create a hypelink that when i click on relevant cell in column A on
tab 1 it automatically takes me to the matching data in column a on tab 2 of
the sheet.