Report

VBA; Copy data between workbooks where sheet name is same

Ask a question K2299 1Posts Monday March 20, 2017Registration date March 20, 2017 Last seen
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.
Thanks
See more 

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!