In the previous tutorial, we covered how to copy sheet tabs within the same spreadsheet with Google Apps Script.
In this tutorial, we will duplicate our tabs into other sheets. Check out the contents:
00:00 Intro setup
01:22 Copy tab to new Google Sheet
10:35 Copy tab to existing Google Sheet
13:17 Copy All tabs to existing Google Sheet
16:03 Copy Selected tabs to existing Google Sheet
18:59 Copy Except certain tabs to existing Google Sheet
We will cover some sneaky tricks to improve your processing speed when running this script too.
Initial Starter Sheet:
https://docs.google.com/spreadsheets/d/1L5SEFfLqTtsNGyEOx7sBxVB30WJxxutuh9yMwxDhcOo/copy
Destination Starter Sheet:
https://docs.google.com/spreadsheets/d/1zaSv9UurP4-JisnixbMO5EnG7aFeGyeqBZngRnQ1N2k/copy
The Playlist: https://www.youtube.com/playlist?list=PLSDEbLgMgqvqP0GQkiYOsH71yUeWBUi-Q
** My Site **
https://yagisanatode.com/
** More on Google Apps Script **
https://yagisanatode.com/google-apps-script/
** Products **
Create and Publish Google Workspace Add-ons with Google Apps Script: Master Class https://yagisanatode.com/products/create-and-publish-google-workspace-add-ons-with-google-apps-script-master-class/
* Courses *
https://yagisanatode.com/products-category/courses/
* Google Workspace Tools *
https://yagisanatode.com/products-category/google-workspace-tool/
* Google Workspace Add-ons *
https://yagisanatode.com/products-category/gwao/
#googleworkspace #googleappsscript #GoogleSheets #GoogeDrive #SpreadsheetApp #DriveApp #admin #googleWorkspace #businessadministration @googleworkspacedevs
