I've entered the code below on Apps Script:
function so5691088602(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheetname = "Sheet1";
var basesheet = ss.getSheetByName(sheetname);
var newSheetName = new Date(basesheet.getRange("B3").getValue());
var NumDups = 30;
for (var i=0;i<NumDups;i++){
basesheet.activate;
var tempDate = new Date();
var printdate01 = Utilities.formatDate(new
Date(tempDate.setDate(newSheetName.getDate()+1+i)), "GMT+10", "MMMM dd,
yyyy");
// Logger.log("DEBUG: Sheet Date = "+printdate01);
ss.insertSheet(printdate01, {template: basesheet});
}
}
It works perfectly by duplicating the active sheet but how do I modify it so it can print the value and formats of the sheet only and not the formulas as well?
Via Active questions tagged javascript - Stack Overflow https://ift.tt/ZCdu0LV
Comments
Post a Comment