• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create cell A1 as a hyper link to file referenced in Cell A2

M

mr_hiboy

Member
Hi,

In Cell A1 have a ProductName, Cell B1 I link to another file to pull in the version number.

I'd like to make the ProductName a hyperlink to the file referenced in cell B1.

e.g.
A1 = ProductA
A2 = "V2" from file ='C:\document\[ProductA - V2.xlsm]Version'!$E$3

I'd like to be able to open [ProductA - V2.xlsm] by clicking ProductA in cell A1

The complexity is that the version file reference changes regular hence the need to refer to the link.

Cheers in advance for any tips.
 
If you are not worried about using another column, you could use the =HYPERLINK function to not only pass the path of the workbook, but also display some value by referring to another cell.
 
Tacking on to Sam's idea, perhaps something like
=HYPERLINK("'C:\document\" & A1 & " - " & A2 & ".xlsm","Click here")
The XL help file for the HYPERLINK function also has several good pieces of information you can use to help you out.
 
You must log in or register to reply here.
Back
Top