Just insert a normal hyperlink that points to any cell in any sheet, but add
an '=' before the text to display.


"Corey" schreef in bericht
...
I have on sheet1(Enter-Exit Page) a list that grows as new sheets are
added, that displays a cell value.
They are displayed in the range O4:O48, as this is the MAXIMUM number of
sheets that the Workbook will contain.
However i want to be able to have the values displayed on the Enter-Exit
Page as a hyperlink to the particular worksheet that value is from.
How can i do this, considering that there amy only be a few values, until
eventually O4:O48 will have values.


Regards

Corey