Situation:
I have 569 folders, and an Excel spreadsheet in each of those folders. Each Excel spreadsheet is named the same as the folder it resides in.
Example:
C:\Project1\ABCD\ABCD.xlsx
C:\Project1\EFGH\EFGH.xlsx
C:\Project1\IJKL\IJKL.xlsx
I have an updated master spreadsheet, MasterSheet.xlsx, that I want to replace every .xlsx file within the C:\Project1 directory structure (and subfolders) BUT I want to keep the current names of the existing files.
Basically, I want to take one file and replace 569 existing ones but keep their current names as-is.
Possible?