Get the "Add Month Sheets Automatically in Excel" workbook from the Excel Worksheet Macros page on my website:
[ Ссылка ]
See how the macro will add month sheets automatically to your Excel file every month, based on another sheet in the file (the Master sheet).
There are two macros in the completed workbook. One macro macro runs automatically when the workbook opens. It runs the second macro, which has the steps for adding the new sheet
This video shows how to set up your Master sheet and save your workbook so it can store macros.
Then you'll see how to copy the code from my website, and paste it into your own workbook.
Next, see how to add the code that runs automatically when the file opens.
Finally, close and re-open the workbook, to test the macros. If the current month's sheet doesn't exist yet, the macro will add it automatically for you.
Video Timeline:
00:00 Intro
00:22 The Master Sheet
01:06 Master Sheet Settings
02:07 Add the Macro
05:55 Test the Macro
06:14 Add Event Code
07:43 Test the Event Code
08:08 Get the Sample File
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: [ Ссылка ]
More Excel Tips and Tutorials: [ Ссылка ]
Subscribe to Contextures YouTube: [ Ссылка ]
