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.
Bookmarks