Copy a files based on excel value
Hi
Am having file names in excel column a and status in column b.
I want to copy a files from one to location to another based on the excel value and update status as found or else not found in column b.
Ex: 123 file name is in excel
123 to be search in source location and 123 will have 3 files with different format's 123.docx. 123.rtf 123.pdf and all these copied into target location and update status as found.
456 is in excel and not found in source location and update status as not found in column b.
Range is column A
Status column B
Each file has 3 format's (docx pdf rtf)
If a file name matches then copy all the 3 formats into a target location.
Source and target location is dynamic.
Like input (enter a source path)
Output (select a target folder).
Your help is appreciated ....
Do the needful.
|