Hyperlink Function
 

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

Hyperlink Function
 

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


"Nev" skrev:

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

Hyperlink Function
 

or maby just jump to the folder

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


"excelent" skrev:

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


"Nev" skrev:

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