问根据条件将单元格值从一个google工作表复制到另一个

EN

//Get the active spreadsheet and store in a variable
function importStudName() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
//Get"Master" spreadsheet and store in a variable
var master_sheet = ss.getSheetByName("Master");
//Get "Miranda" spreadhseet and store in a variable
var miranda_sheet = ss.getSheetByName("Miranda");
//Column T
var columnT = master_sheet.getSheetValues(0, 20, 0, -1);
//Column D
var columnD = master_sheet.getSheetValues(0, 4, 0, -1);
//Column E
var columnE = master_sheet.getSheetValues(0, 4, 0, -1);
//Loop through Column T and find every value that = "Miranda"
    for(var i = 0; i <= columnT; i++) {
        if (columnT[i] === "Miranda") {
          //Set a variable to hold the last row in the "Miranda" sheet
            var miranda_row = (miranda_sheet.getLastRow() + 1);
          //Make the row with the "Miranda" string active

          //Set a variable that concatenates the Column D and Column E variables (from "master" sheet) into a string

          //Copy the new variable to the "Miranda" sheet
            .copyValuesToRange(miranda_sheet, 1, 1, miranda_row, miranda_row);
    }
  }
}