I need to filter and separate 100 PDF files as per Excel sheet

[appc777]

I have 11000 PDF files dumped into a folder located in path: C:\ALL_PDF From these 11000 PDF files. I need to loop in that folder and copy 100 PDF files as per Excel sheet and move them to a folder located in this path: E:/PDF.
Is it possible to create a macro code that will compare my Excel sheet to all of the files inside C:/ALL_PDF , and then copy only those files that match to my Excel sheet and then copy only matching files into the C:/FILTER_PDF
Any help will be greatly appreciated. Thanks
<!-- / message -->

 

[GlennUK]

Are you asking to copy files or move them ( you say both in different places in your posting ). Where are the files to go exactly? You mention 2 different places as the target area.

Have you used VBA at all? Look at the FileCopy command ... it may do what you want.

 

[appc777]

Are you asking to copy files or move them ( you say both in different places in your posting ). Where are the files to go exactly? You mention 2 different places as the target area.

Have you used VBA at all? Look at the FileCopy command ... it may do what you want.

sorry about lack of introduction. let me explain
I have 11000 PDF files @ datafolder located @ C:\datafolder. I need to loop in that folder and copy 100 PDF files as per Excel sheet to newfolder located @ c:\newfolder

 

[appc777]

does anyone know how to do that,

 

[GlennUK]

Hi appc777,

sorry for not responding, but I went away for Easter. Did you get any further with this?

 

[wigi]

does anyone know how to do that,

Please show the VBA-code where you got stuck, then helpers can jump in and take over.