Hi everyone and I hope you can help me. I have an Excel s/s with entries in column 1 that correspond to the PDF's in a folder - that's the easy part!

The next part I need help with and that is that there are multiple entries in column 1 which correspond to each PDF and they can be 1,2,3,4 or any number of instances that correspond to each PDF.

I would like each column 1 entry to hyperlink to the correctly (same) numbered PDF in the folder.

Now I found the following VB code which creates the hyperlink to each PDF in a folder but I want it to also hyperlink when there are multiple entries of each instance in column 1.

Ideally I would like it to just produce the filename, hyperlinked without the path or any other info.

Thank you in advance and here is the code for hyperlinking to a folder.