I have this excel workbook that has a tab for every month. This tracks awards given to my employees. I have a main sheet named Master that holds a few formulas to randomize and the template for the tracker.
I need a code that I can put into a button that when pressed creates a new sheet, renames it according to the current month (this is not a MUST HAVE since I can rename myself) and copy and pastes the template with the formulas.
The range in the Master tab is A1:L67
Can it be done?
Thank you!
I need a code that I can put into a button that when pressed creates a new sheet, renames it according to the current month (this is not a MUST HAVE since I can rename myself) and copy and pastes the template with the formulas.
The range in the Master tab is A1:L67
Can it be done?
Thank you!
