Excel AUTO HYPERLINK
Heres what I want to do:
I have multiple folders with multiple files in them, which range from 100-5000 different documents (all of which are PDF). I have column "A" containing numbers from 1 - my last file.
The files I have in my folders are named
"Doc 1 - 100-52"
"Doc 2 - 526-231"
"Doc 3 - 426-634"
for instance.
I want to make Excel hyperlink cell A1 containing text "1" to "Doc 1 - 100-52"
Is this possible? I don't care to use VBA or anything else I just want it to work! Please someone with more knowledge help me. I have combed google and havent found anyone wanting to do this or who has done it. Any help would be appreciated. Thanks!
|