00:00If you're in a business of making extra cash by selling templates on KDP and Etsy, this is the
00:05Excel tip you must watch. For example, if you have a daily planner like mine here and you want to
00:10create multiple of this same worksheet template on one workbook, maybe 365 worksheets for each
00:17day of the year, this is how you would do it. First, you're going to press alternate F11 to
00:21open a VBA editor and paste this VBA script. First section of this VBA is actually for you
00:27to customize it. I'm going to generate 365 worksheets here with my prefix and my suffix
00:33and this is my template name. Now, if you need a copy of this VBA or need a detailed explanation
00:38of how this VBA script works, drop me a line on the comment section and I'll get you both the
00:42VBA
00:43and how to apply this to your worksheet. Now, press Ctrl S to save and close your VBA editor. Now,
00:49if you select any cell on your worksheet, you will auto-generate 365 worksheet just like that.
00:58Let's go.
00:58.
00:58.
00:58.
00:58.
