Dynamic Hyperlinks

[acmichae]

Hello,

I have a spreadsheet of data where each cell of data needs to be hyperlinked to a corresponding PDF file. Say one cell in this column of 100 rows is "M0004125". This needs to be hyperlinked so that when clicked, it opens up the PDF file named "M0004125" in the folder 'C:\Users\Myself\Documents\Data Files"'. While I am able to hyperlink each cell individually through "right-click and hyperlink", this is very time consuming since I have so many data points to hyperlink. Is there a function out there that allows me to type out once, and then drag down through all cells in that column?

Thank you!

[arunsjain]

Hi

Try following code. I assumed list of files in Sheet1, Column A and starts from Cell "A2". If not, you can update it accordingly. I hope it will help. Cheers!!!

Please Login or Register  to view this content.

[acmichae]

Thank you Arunsjain, that worked!