Simple Question

[icruckus88]

I am looking for a macro to create two new tabs when I press a button, each displaying the current month and copying the data from the previous month and updating to this month. I currently copy and paste the data manually. Is there a simple fix for this?

Thanks

 

[texasalynn]

Welcome to MrExcel Board....

use the macro record to create the macro. Then you can see about cleaning up the macro so that you can make it generic for repeated use. After you record the macro and you have questions, post back with the code. You will learn so much more by doing this.