This works perfectly but it would be nice if it were written more elegantly.
What it does is open spreadsheet files with month and year as part of the file name. It then copies a specific worksheet from each and pastes it back into a specific page of the spreadsheet that contains the macro. I'm thinking it would be easy to loop but I didn't know how to change my variable names with a loop:
Please Login or Register to view this content.
Bookmarks