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