Need to locate specific sheet, export/save as PDF with a specific filename.

I need to be able to search and match a unique to a list of filenames and then export/save as the sheet with that filename. Below is how I use to do that. Now that we have changed systems, the format has changed. Column A should be unique and should not have any duplicates. However, if there are, then I need to know and not just name the files. I have attached a workbook that shows the process. I will start with the "All Notes" sheet and then I'll run a macro that splits that up into the other sheets. (I have another post to help me with that). Then I will copy and paste the filenames from another sheet into this workbook on their own sheet. Then this macro would be used to locate the notepad, export and save. I need a macro because this may be 150+ separate sheets that this has to be done with. Can anyone help modify the macro?

Please Login or Register  to view this content.