I want to create a macro that can automatically:
-copy all the excel sheets in a folder
-paste these excel sheets in a new folder
I've found various information about how to move copy and paste data from one worksheet to another, or how to combine data into one 'master' spreadsheet, but nothing about copying workbooks and pasting them in a new folder.
Any suggestions or tips?