!d2079f4e0a8872386335.md

###Copy Google Spreadsheet Values

Code.gs

var settings = [
  {
    from: '1TdiT4vPOiSenwCNTvE3cQTKUC7w-NFKSZ0mo2F5n7Lo',
    to: '1TdiT4vPOiSenwCNTvE3cQTKUC7w-NFKSZ0mo2F5n7Lo',
    fromRange: 'ЛистА!A1:C10',
    toRange: 'ЛистБ!A1:C10',
  },{
    from: '1TdiT4vPOiSenwCNTvE3cQTKUC7w-NFKSZ0mo2F5n7Lo',
    to: '1TdiT4vPOiSenwCNTvE3cQTKUC7w-NFKSZ0mo2F5n7Lo',
    fromRange: 'ЛистА!A12:C13',
    toRange: 'ЛистБ!A12:C13',
  }
];
function copyRange() {
  for(var i in settings){
    var values = SpreadsheetApp.openById(settings[i].from).getRange(settings[i].fromRange).getValues();
    SpreadsheetApp.openById(settings[i].to).getRange(settings[i].toRange).setValues(values);
    SpreadsheetApp.flush();
  }
}