Excelexcel86
Board Regular
- Joined
- Feb 28, 2023
- Messages
- 99
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi guys I’m looking for a macro to do the following. I have about 16 folders in total with different amount of data in all what I’m hoping to do is for every folder copy the most recent file they are csvs and put into master workbook but then when the original folders have new data put into them I want to copy the new file but then replace the file that was in the master from that folder .so basically it ends up with 16 files in master folder where each file is always the newest .