Hi all,
How to copy Jpeg files from one folder to another folder with file name reference in excel. Eg. as below
I want to do medical insurance for my employees, for which I need to send their photos. I have all photos of staff and workers in one folder with their employee number as file name.jpg.
I want to select only worker's photos and copy them to another folder to share the same to the insurance agency, with reference to their employee number as base reference.
Eg:
Pic file name in a folder as below
9100567.jpg
9100486
9101592
name list in excel as below
Emp.No
9100567
9100486
9101592
please help me to get this automation to solve my time-consuming work.
Thanks
Raghavan
Bookmarks