After an incredible summer vacation (see my post about the Google Innovator Academy, the huge American road trip across the mid-west, and even a short trip to Spain) I am back in the office and already knocking out some code!
A colleague asked me about a way to duplicate sheets inside a Google spreadsheet. He has a template for his weekly schedule built inside a sheet, and he wants to duplicate it for each week of the school year.
A very reasonable request, however, I wasn’t exactly clear how to do it. In five minutes I whipped together this little script.
A short explanation of the code:
First, you declare the number of duplicates you want. Second you create the spreadsheet object. Third, you loop over the object and each time create a duplicate of the activate sheet. Finally, run the script and watch it take away 10 minutes of manual labor!
In other news, I am going to start posting lots of code snippets that help me and my colleagues solve small problems and make our lives easier. You can help me out by making your own suggestions on my project site http://plnnr.net (work in progress, but you can still use it!) I would love to help figure out ways to improve teacher workflow!