Hi everyone,

I am trying to automate a process using VBA.

I have a excel file updated with file name, provider name, year, quarter in different columns.
I want to move all the files listed to respective, *\provider_name\Year\Quarter sub-folders. Can you please help me with the VBA for this.

Also, can VBA create the folders, if like provider_name folder doesn't exist?

Thank you!