I searched on many websites but did not get similar things. I am sharing my thoughts. Hope someone helps me with the suggestion, sample file, or link.
In my worksheet Cell, E9 to E100 has Some names. I want to make those names as hyperlinks.
There are few folders in "E:\Names\ " having exact same name of E9 to E100 column ( E9:E100 is the column range).
Now the facts:
Now If the folder name matches the cell String then the hyperlink creating on that cell.
If there is a folder which name is not matched with any cell string then nothing happens.
If there is a cell string but no folder is matched exact same name in that directory then a folder will be created based on the name of the cell string along with the hyperlink.
If any new name is add in cell E9 to E100 then automatically a folder will be created along with the hyperlink.
Can it be done with VBA? If so, please.
Thank you in advance.