I have an Excel table built with a data connection to a folder. Works great, updates as files are added to the folder.
One of the table columns is named "Sample number". When selected, I want the sample number to open a corresponding PDF file.
An example of a "Sample number" would be 202106102266. When clicked, it would open the file "R00202106102265 + 202106102266 (Allred 2 Apple Fuji).pdf" in the directory C:\Users\jtmcc\NCC Results\PDF files\.
Likewise, clicking sample number 202106102265 in the workbook would open the same file.
What's the best way do that? Macro or formula? Can you provide an example please?