Copy multiple files in different folders

Hell Everyone,

I'm currently stuck on this VBA Code. What I'm trying to do is copy files in a directory using an Excel macro.

For example, A2 is the source folder and B2 is the destination folder and C2 is the file name. The code that I use only work for the source & destination in the first column (i.e, the destination in B2 remains same for all the file names. The macro shared in the thread http://www.excelforum.com/showthread...13#post4542813 is for multiple files from one source folder to one destination folder. In my case source and destination folder change as per the list

Please Login or Register  to view this content.

Thanks and Regards!