I have raw data (.xls) and using a macro I can tidy this up (adding header, text to number etc.) I then rename the sheet for the corresponding month and save the file as .xlsx . This is repeated throughout the year. I have a master file with a separate worksheet for each month and I want to copy and paste values where the sheet names are the same, comparing the sheet name in the monthly file with the sheet name in the master file. Any help would be greatly appreciated. Both the monthly file and master file will be open at the same time so I do not need to try to open files within the code if that makes it simpler.
VBA; Copy data between workbooks where sheet name is same