Hyperlink question

[WithaY]

Let me start by saying I am your basic Excel user. Basic. I have a project that involves hyperlinks to other documents. Here is the scenario:
I have about 6000 individual pdf documents in a folder. They are each titled something different. I then have my main spreadsheet where I have all of my information that I need to link to these 6000 individual documents. Example: ABC-008234 will need to be linked to that exact named document among the 6000. Next would be ABC-008235 to be linked to another document in that 6000. I have over 6000 ABC numbers to link. The only way I have found so far to enter the hyperlink is to go through all the steps for each ABC number (Insert Hyperlink, go clicking through all the folders, find the document, etc. for the address). I know I can at least attach the "base" I guess by going to the Menu, Prepare, Properties and putting the base link to at least that main folder in that location. Is there any type of global wildcard I can enter where it goes to the folder and magically finds that named document??

Thank you to all for their patience reading this and trying to help a lost soul!

 

[WithaY]

Tom -

Again - my hat's off to you, Sir. Thank you so much for taking the time to help a lost soul in Excel!

Have a wonderful weekend! If there are any problems, I'll let you know (and I am keeping this bookmarked so I can reach you again with my next adventure!)

Lynda

 

[WithaY]

Sorry - forgot!

I will do the single sheets for now because there will be a sheet at the end that has "questions" for my boss.

If I could, however, ask you - how would the macro be modified? I know it's something I can't do, but if you could, could you tell me how, just in case?