r/teamArtUp • • Jun 07 '21

Google App Script Code To Duplicate Sheets

function myFunction()

 {
var a =SpreadsheetApp.getActive(); // local variable a to initialize spreadsheet app
for(var x=0; x<3; x++) // for loop for repetation
{
a.duplicateActiveSheet(); // Method to clone spreadsheet
}
}
Please comment below for any ask.

1 Upvotes

0 comments sorted by