Fellow Forum Members,

I have searched the past postings without success. I am looking for code to copy and paste pdf files from a source folder into a destination folder based on a reference list in Excel. Each month, I distribute 100+ signed project status reports to various directors. Each director wants to see only his own project status reports, not the whole package. I have a list in Excel in which I track each project (column A) and the responsible director’s folder path (column B).

Ideally, after I scan in the package of signed reports, and run a split utility in PDF to separate each report, I would run this code to look in the source folder, and sort the reports into separate folders based on who they belong to. That way, I can just maintain the Excel list, and don’t have to manually sort hundreds of project reports each month.

I imagine that the code would be something like this:
Look in source folder, if filename from column A matches a file in source folder, copy to corresponding path in column B.

Source folder (where I save the original PDF’s) is “U:\”
Destination folder is S:\project controls 11143\”directors name”

Any help you can provide would be greatly appreciated!!