Excel - Hyperlink Function

Asked By Nev on 05-Jun-10 09:26 AM
Hi there

How can I put a variable in a hypelink?
I want to access a folder  within management - that folder is dependant on a
variable in cell j10.  ie whatever name is in J10, click the cell and the
hyperlink will take you to the folder in c:\management\???

Can you help?

thanks

nev


excelent replied to Nev on 06-Jun-10 05:13 AM
=HYPERLINK("[C:\management\"&J10&"\Urfile.jpg]","Jump to whatever")
excelent replied to excelent on 06-Jun-10 05:27 AM
or maby just jump to the folder

=HYPERLINK("[C:\management\"&J10&"]","Jump to whatever")