It is January, the start of a new year. As such you may find you need to add 12 new worksheets, one for each month of the year, to your existing workbook. But this year you decide you are sick of doing monotonous, repetitive, mindless work of open the workbook, adding a new sheet, renaming it January, adding another new sheet, naming it February, etc. etc. until you have created a sheet for all 12 months of the year. Isn’t there a better way?

The answer is yes. You can have a VBA macro do the tedious work for you. Just follow these steps to create the macro.

How to create the macro

1. Open Excel.
2. To open the VBA Editor, press Alt + F11.
3. To display the Project Explorer, select View > Project Explorer from the menu.
4. To display the Project Explorer’s folders, if necessary expand the VBA Project (PERSONAL.XLSB) with the plus sign, and then, if needed, expand the Modules with its plus sign.
5. To add a new module, first click on the Modules node, and then select Insert > Module from the menu.
6. Copy and paste the code below into the new module.
7. To save the Personal Macro Workbook, press Ctrl + S or select File > Save Personal.XLSB from the menu.
8. To return to Microsoft Excel, press Alt + Q or select File > Close and Return to Microsoft Excel.

How to use the macro

1. Open Excel.
2. To view the list of macros press Alt + F8 or select View > Macros > View Macros from the ribbon.
3. To launch the macro either click the PERSONAL.XLS!AddMonthlySheets and then click run
   or just double click the PERSONAL.XLS!AddMonthlySheets macro.

Excel will then add 12 sheets to your workbook, one for each month of the year.