bat.fire.sheet.js

function fireselected(){
  var spreadsheet = SpreadsheetApp.getActive();
//Logger.log(spreadsheet.getName());

  
  if(spreadsheet.getSheetName()!=="Vouchers")return Logger.log("not vouchers page");
  if(spreadsheet.getActiveRange().getColumn() !== 2)return Logger.log("not second column");
  if(!spreadsheet.getActiveRange().getValue().match(/#/g))return Logger.log("wrong cell");
  

  return Logger.log("done");
  var VRowIndex = spreadsheet.getActiveCell().getRowIndex();
  
  
  
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('FireLeft'), true);
  
  
  var lastEmptyInFireleft = 0;
  var initialScanStart = 250;
  var column = spreadsheet.getRange('B'+initialScanStart+':B');
  var values = column.getValues();
 
  
  while ( values[lastEmptyInFireleft][0] != "" ) {
    lastEmptyInFireleft++;
  }
  
  var finalLastEmptyInFireleft = lastEmptyInFireleft+initialScanStart;
  
  Logger.log('Vouchers!B'+VRowIndex+':Y'+VRowIndex);
  Logger.log('O'+finalLastEmptyInFireleft);
  Logger.log(finalLastEmptyInFireleft);
  //Logger.log(VRowIndex);
//  return;
  
  
  spreadsheet.getRange('B'+finalLastEmptyInFireleft).activate();
  spreadsheet.getRange('Vouchers!B'+VRowIndex+':Y'+VRowIndex).copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('G'+finalLastEmptyInFireleft).setValue('?');
  spreadsheet.getRange('O'+finalLastEmptyInFireleft).activate();
  spreadsheet.getCurrentCell().setFormula('=now()')
  spreadsheet.getCurrentCell().setValue(spreadsheet.getCurrentCell().getValue());
  
  
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Vouchers'), true);
  
  
  spreadsheet.getRange('B'+VRowIndex+':O'+VRowIndex).copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('B'+VRowIndex+':Y'+VRowIndex).setBackground('#ffff00');
  spreadsheet.getRange('C'+VRowIndex+':E'+VRowIndex).setValue("resigned");
  spreadsheet.getRange('S'+VRowIndex).setValue("");
  
  
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('FireLeft'), true);
  spreadsheet.getRange('G'+finalLastEmptyInFireleft).activate();
};