1st time poster and VBA newby. I'm looking for a macro to copy a set .pdf files to a new folder(to be created if not already made) corresponding to the person they are assigned to. I have a snip below to show the columns(D&K). Right now we have all the IWP files matched with a similarly named .pdf in a folder(X:\03_IWP\IWP pdf) and I am looking to copy them into a new folder based on the Superintendent in another location(X:\03_IWP\Superintendent).

Thank you for any help you can give!

Currently using excel 2016

Annotation 2019-12-04 102451.jpg