I have a folder which has multiple files and the number of files is not fixed . Also the multiple files are stored in different folders. I need to copy all the files from these multiple folders to a single folder. While the number of files in each folder is not fixed, each folder name is standardised. Example Folder Named A may have 10 files and Folder Named B may have 20. I know that you can use select all and copy but since I have many folders with these multiple files and I need to go to each folder and do select all/copy to the destination folder, this can be very time consuming. Is there a VBA to automate this function?
Bookmarks