How to Quickly and Easily Move Google Sheet Tables to Another Sheet | google sheets
Struggling to manually copy-paste tables from one Google Sheet to another? In this video, I'm going to show you an easy way to do it quickly and efficiently using google scripts. Learn how you can save time and energy on tedious & repetitive tasks and maximize your productivity with this awesome tool!
function sendTable() {
var sheetFrom = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
var sheetTo = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2");
var tableRange = sheetFrom.getRange("A1:D11"); // Change the range to the table you want to send
var tableData = tableRange.getValues();
sheetTo.getRange(1, 1, tableData.length, tableData[0].length).setValues(tableData);
}
#rover #googlesheets