Hello,
I currently have a macro that I run to create quarterly folders needed for payment processing that's pretty straight forward. Each month, we use a few different spreadsheets to do analysis, and I've been manually placing them in all of the folders after they are created. Is there something I could build into the macro that would create the folders and contain the spreadsheets we need for analysis? The spreadsheets are never renamed and are always in the same folder on the network.
Thank you!
I currently have a macro that I run to create quarterly folders needed for payment processing that's pretty straight forward. Each month, we use a few different spreadsheets to do analysis, and I've been manually placing them in all of the folders after they are created. Is there something I could build into the macro that would create the folders and contain the spreadsheets we need for analysis? The spreadsheets are never renamed and are always in the same folder on the network.
Thank you!