Macro to Move Files from a Folder to Newly created folders based on value in a cell

Dear Friends,

I have a set of files in a single folder (the physical file names are matching with the names mentioned in column B).

Now, I need to move the files, which names are mentioned in column B with creating new folders in the names of column C. My data is like this:

Please Login or Register  to view this content.

In the above example, the files Hello1.docx, Hello5.xlsx, Hello7.pdf, Hello9.xlsx are to be moved into a new folder named "CategoryA" (i.e. 4 files to be moved). Similarly, in the folder name of "CategoryB", Hello2.docx, Hello4.xlsx, Hello6.pdf (3 files) are to be moved. And such files are to be moved and the current folder must be kept empty after its movement to relevant folders.

I request your kind help to do this process of moving files to specific folders.

Try this. Change the path of the "Main" folder to suit.

Please Login or Register  to view this content.