Thread: Hyperlinks:How would I do this?

Let’s suppose I have a hyperlink to a folder “C:\Program Files” {=HYPERLINK("C:\Program Files")} in cell A1. In cell A2, I want to add/reference that hyperlink to the first folder in the C:\Program Files folder using the A1 hyperlink location as a reference. How would I do this? You see, I have hundreds of folders that I want to hyperlink to on a network. The final folder name doesn’t change, but the location does. I want to be able to simply change the reference location, in A1, and have it update the rest of the sheet.

You'd need to concatenate the formula,

So you'd need to add

"&A2&"

Just like that into your hyperlink string

Eg

=HYPERLINK("C:\Program Files\"&A2&"")

I was trying to avoid having to type in the whole path in each cell. Basically I should ony have to type something like this:

=HYPERLINK("A1", "\Adobe") and have it take me to the 'C:\Program Files\Adobe' folder. Can't seem to get it right though. This way if cell A1 'C:\Program Files' changes to, say, 'C:\Program Files 1', I can simply update the A1 cell and have the rest of the hyperlinks to their respective folders.

Thanks for the idea though.

Any other suggestions please?