Moving Multiple Files from One Folder to Another (Create Folder & Save Files)

[MaunishP]

Dear Team,

I am looking for macro which will move multiple files from one folder to another. Below given is detailed request what i am looking for :
1) I need first macro to create folder name based from column A then ....
2) Then move files which are aligned with respected batch code (from column A) to specific folder name then ......
3) Path of new files to be displayed in column D.

I have attached excel file for reference.

Please feel free to msg me in case of any detailed clarification required.

Regards,
Maunish Patel

// Unfortunately excel file is not getting uploaded hence pasted data below given :

BatchCode File Name Original Files Path To be saved
FS-AHGC-01 Maunish Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad
FS-AHGC-01 Kanak Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad
FS-AHGC-01 Mihir Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad
FS-AHGC-01 Hitarth Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad
FS-BGC-01 Meha Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad
FS-BGC-01 Hemit Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad
FS-BGC-01 Purvesh Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad
FS-BGC-01 Manisha Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad
FS-BGC-01 Sharvya Patel 1122334455 CV.pdf C:\Users\Hitarth Patel\Downloads\jugad

 

[vletm]

MaunishP
Why do You would like to do that with Macro?
Why not manually?
Where comes those files?
... Could those files save to needed folder while those have created?