Get the code here https://www.bluepecantraining.com/excel-vba-organise-files-into_subfolders-file-type/
This video demonstrates how to write the VBA code that will organise files into subfolders by file type. The code will do the following:
1) Prompt the user to select a folder to organise
2) Create a new folder to copy the files to in the same parent folder as the original folder
3) Loop through each file in the original folder
4) Create a sub-folder for each file type (making sure the folder doesn't already exist)
5) Copy files to the correct sub-folder
5) Delete the original folder
The subprocedure uses the FileSystemObject
------------------------