Macro to move file to another folder based on the names

**kriahnadas.oo7** · 06-13-2013, 10:35 AM

Hello friends,

Need some help on macro. I have the files for each client on their names (eg; for the client AA, i have the file named AA.xls) on a particular folder.

The requirement is, 1) have to create folder for each country for the respective clients and 2) move the files to the respective folders for which the client belongs to based on the sheet attached.

File path is C:\Users\DD\Desktop\New Folder\AA.xls

Destination is C:\Users\DD\Desktop\NewZiland\

Can somebody help me with a macro for this.

Many thanks in advance...

Regards.

**JBeaucaire** · 06-13-2013, 11:26 AM

Do the folders destination folders need to be created?

**JBeaucaire** · 06-13-2013, 11:33 AM

If all the folders exist, then this should work:

Please Login or Register  to view this content.

**kriahnadas.oo7** · 06-17-2013, 02:29 AM

Hi, Thanks for your effort. Unfortunately there are some challenges which i am facing. I think i should explain the case again for more clarity.

The folders are existing there so no need to create those again.

And the files with client's name is also ready with me.

The macro should search for the respective folders and move the files with client name to the respective folders as per the sheet.

Thanks in advance....

**JBeaucaire** · 06-17-2013, 09:55 AM

That's what that code above is designed to do based on the info given in post #1. Having read through the code, is there any part you don't understand?