Google Sheets:根据单元格值将行移动到其他工作表，然后再移回

function moveRows() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var sourceSheet = sheet.getSheetByName("源数据工作表");
  var targetSheet = sheet.getSheetByName("目标数据工作表");
  var triggerCell = sourceSheet.getRange("A1");
  var triggerValue = triggerCell.getValue();
  
  if (triggerValue == "移动行") {
    var lastRow = sourceSheet.getLastRow();
    var range = sourceSheet.getRange("A2:D" + lastRow);
    var values = range.getValues();
    
    for (var i = values.length - 1; i >= 0; i--) {
      if (values[i][0] == "移动行") {
        targetSheet.appendRow(values[i]);
        sourceSheet.deleteRow(i + 2);
      }
    }
    
    triggerCell.setValue("已移动");
  }
}