COPY FILES FROM ONE LOCATION TO ANOTHER BASED ON THE LIST GIVEN IN EXCEL SHEET USING VBA​

Hi,

I need a macro for BROWSE, SEARCH AND COPY FILES FROM ONE LOCATION TO ANOTHER BASED ON THE LIST GIVEN IN EXCEL SHEET USING VBA.

Range is selected in excel

Source path: "Shold be given manually"

Destination path: "Shold be given manually"

Msg "Files Copied "

Besides list name colum can we update "copied" if it found and "N/A" if it is not found.

Format types: .doc, .rtf , .docx , .xlsx , .pdf