Excel functions and macros

J

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?
 
S

Stephen Bye

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

J

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

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")




.
Click to expand...
 
Top