Use cell content in hyperlink

[Excelski]

Hi,

How can I use the contents of a cell as part of the file path in a hyper link

I am using the following and want to replace cccccc with the contents of H4

=HYPERLINK("Q:\XXX Design\1. XXX bbbbb Designs\cccccc","File here")

Thanks
Kevin

[dominicb]

Good afternoon Excelski

have you tried putting the full path and filename in cell H4, and then just use :

Please Login or Register  to view this content.

This worked OK for me.

HTH

DominicB

[Excelski]

Good afternoon Dominic,

H4 is the result of a lookup and only part of the path name, it is also used elsewhere so needs to remain as it is.

If I can find a solution I am hoping it will allow me to drag it down over many rows which will save work!

Thanks for looking

Kevin

[dominicb]

Hi Excelski

Please Login or Register  to view this content.

The above also works.

Beyond that, you may have to attach a cut down version / mock up of the file so that I can see what you are seeing.

HTH

DominicB



Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitise the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Excelski]

Hi Dominic,

Thanks that worked!

Kevin