I have been at this for days now trying different methods and pouring through internet for similar questions. All I've come across is paid tools. My predecessor had a workbook that would take a list of file paths of .doc and .pdf files from a sharepoint folder and copy them to a new destination; I know its possible, I just cant figure out how, he deleted the file when he left.

The source file are all in sharepoint. All the .docs are in one folder and all of the .pdfs come from another. We arent moving the whole folder, only those that meet certain criteria. Which is why we are using the excel sheet to capture the files we want to move. We have over 9000 files.

I have the path of each individual .doc file we wish to move in column A and its paired .pdf in column B. All of the .docs will copy to a DOC folder and all of the PDFs will copy to a PDF destination folder.

Please tell me there is an easy macro for this? HELP!