Move Files from Folders and Subfolders to Destination address given in Column C

Hi Friends!!

I have list of files Names in Column A, their path (source) in Column B and destination path in Column C. All starting from Row 2.

I want to move/copy the files listed in column A to the destination path given in Column C.

I have already created folders and subfolders in the destination path.

Example:
File Name (Col A) Source (Col B) Destination (Col C)
1920531424.xls C:\Users\ravaan\Desktop\KHARIFF SRPT 20-21\APRIL 2021\Cheque 388615 dt.06.04.2021 Rs.15962084\ C:\Users\raavan\Desktop\VARIETIES\2019-20\BRA
202153621.xls C:\Users\raavan\Desktop\KHARIFF SRPT 20-21\SEPTEMBER 2021\07 CMP Rs.10677387 Dt.16.09.2021\ C:\Users\raavan\Desktop\VARIETIES\2020-21\RRA

I want to move/Copy file "1920531424.xls" which is in source path as above to destination path. The Folder "Varieties", Subfolder "2019-20", sub-sub-folder "BRC" is already created. I just must be able to move/copy.
I want to move/Copy file "202153621.xls" which is in source path as above to destination path. The Folder "Varieties", Subfolder "2020-21", sub-sub-folder "RRA" is already created.

I am attaching workbook with list of file names for perusal.

Please help.

Backup all your source folder and files first.

Then try this :

Please Login or Register  to view this content.

I only tested to the first 4 rows of data in Sheet1.

@karmapala

Thank you very much. Solved issue.

Glad I can help, Ravana.