bat.weeklymove.sheet.js

function companyBankVouchersMove() {
  var initialScanLocation = 69;
  var spreadsheet = SpreadsheetApp.openById("-");
  
  
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Company Bank'), true);
  var column = spreadsheet.getRange('D'+initialScanLocation+':D');
  var values = column.getValues(); // get all data in one call
  
  var location = 0;
  while ( values[location][0] != "" ) {
    location++;
  }
  
  location = location+initialScanLocation;
  
  var time = new Date().toLocaleString('lt');
  
  var elm1 = spreadsheet.getRange("D" + ( location-1 ) + ":D" + location);
  elm1.setValues([[elm1.getValues()[0][0]],["=Vouchers!$G$3"]]);
  elm1.setNote("script touched this elm1 on "+time);
  
   var elm2 = spreadsheet.getRange("G" + ( location-1 ) + ":G" + location);
  elm2.setValues([[elm2.getValues()[0][0]],["=Vouchers!$P$3"]]);
  elm2.setNote("script touched this elm2 on "+time);
 
}