bat.dublicatevouchers.sheet.js

function COPYVOUCHERSONDATE() {
  //if(new Date().getDay()!=6)return Logger.log("not today ;)");
  
  var DATETIMESTRING = Utilities.formatDate(new Date(),"GMT+1","M/d");

  var spreadsheet = SpreadsheetApp.openById("-");
  
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Vouchers'), true);
  spreadsheet.duplicateActiveSheet();
  spreadsheet.moveActiveSheet(17);
  var sheet = spreadsheet.getActiveSheet();
  
  sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns())
  .setDataValidation(null)
  .copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  
  try{sheet.setName(DATETIMESTRING+"-bha");}catch(err){Logger.log(err)}
  
  
  sheet.getRange('1:1').clear({contentsOnly: true, formatOnly: false, skipFilteredRows: true}).setBackground("green");
  sheet.getRange('B1:C1').merge().setValue("DUBLICATED ON: \n"+new Date().toLocaleString('lt')); //setWarp(true)
  
  sheet.clearConditionalFormatRules();
};