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!