Preview:
function SetOtherSheets() {
  var app = SpreadsheetApp;
  var SetOtherSheets = app.getActiveSpreadsheet().getActiveSheet();
  
  // เลือกชีทตามชื่อ
  var targetSheet = app.getActiveSpreadsheet().getSheetByName('Sheet20');
  //targetSheet.getRange(1,1).setValue(7);
  var tempNumber = targetSheet.getRange(1,1).getValue();
  // นำค่าไปเขียนไว้ที่ชีทอื่น
  var secondSheet = app.getActiveSpreadsheet().getSheetByName('Sheet19');
  secondSheet.getRange(10,1).setValue(tempNumber);
}
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter