I think my question has been answered somewhere in forum, but I had no luck in my search results.
I have a folder list in column G and name list in column H. What I want is make each of the cells in column H hyperlinked with the relative folder locations from column G. That is, when I put my excel file in the same folder as the parent folder of column H folders, I want to be able to open Folder-1 when I click Name-1.
Note: By the way formula/function solution i.e.won't do. I need a macro that inserts hyperlink without changing the text of column H.Please Login or Register to view this content.
I tried to explain my case in following screenshot
Hyperlink.png
Bookmarks