saving files in specific folders dynamically

[TapiwaMaseko]

Hi All,

I am a vba novice and often get around most challenges by recording macros. I have a problem which unfortunately recording a macro cannot solve.

I have thousands of PDF files saved as employee's "FirstName LastName" I also have a folder with hundreds of subfolders saved as line manager's "FirstName LastName"


I have an excel file with the employee's FirstName LastName Column and another column with the line manager's FirstName LastName

Is it possible to loop through the file with PDF employee files and save each in a subfolder as per line manager in the excel file?

Just wanted to ask you experts if this is any feasible at all as it looks fairly complex to my small brain.

Thank you

[Mumps1]

Have a look at this link: https://analysistabs.com/excel-vba/c...der-directory/
You could loop through the employee name column to save a copy of each file to the corresponding folder using the manager name column.

[TapiwaMaseko]

Looks promising and will take a look. Thanks Mumps1

[Mumps1]

My pleasure.