Hello,

I have a spreadsheet with over 1,000 calculation names in it. Each of the calculations has a corresponding PDF and the file names of these PDFs are around 16 characters long with the last four characters being the calculation number. I want to create a code so that I can type the calculation number into a cell and then the corresponding PDF to open. The PDFs are saved in one folder, however in separate subfolders, so the VBA will need to be able to search in the subfolders

I'm a complete novice to VBA, so any help would be greatly appreciated!