I have a folder named Directory. Within the Directory folder, there are about 3,000 subfolders. I have to pull out about 1,000 of these subfolders. Each subfolder is named after an employee; last name, first name.
I have an Excel spreadsheet and in column A is the name of the employee that needs to be pulled out of the Directory folder. So for example, if Jones, Mary is in column A2, then the macro needs to identify Jones, Mary subfolder and move (not copy) the subfolder and its contents to another folder. So in the end, I will have a thousand subfolders in one folder. Also in Column B there are some employee ID numbers associated with each name in Column A. If there is an employee ID number, can that be attached to the file name, eg. Jones, Mary – 11223?

If you have another idea on how to do this, I am open for suggestions. Thank you very much.