Excel functions and macros

[J]

How can I create a function or macro that will alow me to
click on a cell and have that cell take me to a worksheet
within the document?

 

[Stephen Bye]

You can do this with the HYPERLINK function, for example:
=HYPERLINK(Sheet2!B2,"click here")

 

[J]

Hi! I tried this and it is not working. It won't bring
me to the page but shows the link.

 

[J]

I figured it out! Thank you very much!

-----Original Message-----
You can do this with the HYPERLINK function, for example:
=HYPERLINK(Sheet2!B2,"click here")




.