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);
}
Preview:
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