Hi folks!
I've got a folder that has 5000+ pdf's in it. I've got a spreadsheet as shown below. I'd like to run a sub that copies the pdf's in the original folder and pastes them into the new folder..
Is anyone able to help?
<tbody>
</tbody>
Thanks!!
I've got a folder that has 5000+ pdf's in it. I've got a spreadsheet as shown below. I'd like to run a sub that copies the pdf's in the original folder and pastes them into the new folder..
Is anyone able to help?
PDF Name | PDF Type | Current Folder | Copy to New Folder | |
pdf001 | Type 1 | C:\MyPDFFolder\ | C:\MyPDFFolder\Type1\ | |
pdf002 | Type 2 | C:\MyPDFFolder\ | C:\MyPDFFolder\Type2\ | |
pdf003 | Type 3 | C:\MyPDFFolder\ | C:\MyPDFFolder\Type3\ | |
pdf004 | Type 1 | C:\MyPDFFolder\ | C:\MyPDFFolder\Type4\ |
<tbody>
</tbody>
Thanks!!