lina
0
Q:

stackoveflosw

` function myFunction() {
  s.getRange(3, 7, 1, 3).clear()
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s = ss.getSheets()[0];
  s.getRange(3, 7, 1, 3).clear()
  var celda = s.getRange(3, 1).getValue()
  for (var i = 1; i < 13; i++) 
  {
    var bar = s.getRange(i, 2, 1, 3).getValues(); 
    if (celda == s.getRange(i, 2))
    {s.getRange(3, 7, 1, 3).setValues(bar);
    }
  }
}`
0

New to Communities?

Join the community