Macro to Copy PDF Files to Destination folder based on cell information

[harinsh]

Hi Everyone,

I'm looking for one assistant....I have folder which contains 100+ PDF files and these file names I have it in my excel say it start from A2 cell... I would like to move PDF files to different folder based on PDF file name which is there in the excel sheet....

For Example: If A2 cell value says "CITY-NW-2012" then same file name will be available in the given folder path so, it should get copy and to paste it in destination folder which I choose....

Is it possible to perform this activity through excel macro?? If yes can anyone will provide me the vba code....it would really helpful if I get this output....

Thanks you,

 

[dptmshr]

Hello,

I have got the same requirement where i have one folder containing 1000 of pdf files and another excel list which contains the file name and destination folder name.The macro should go look for the folder name at destination if not found create one and paste the file.If folder exists then dont create new but just copy.
I was just wondering if you were able to fix your above issue which might help me as well.
Thank you