Answer the question
In order to leave comments, you need to log in
Google script, transferring data from one sheet to another?
There are two codes:
The first one inserts info on the right
function addtodescriptionright(){
var ss1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Генер");
var ss2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Лист14");
var values = ss1.getRange(1, 1, 14, 1).getValues();
Logger.log(values);
var r = ss2.getLastRow();
var r1 = ss2.getLastColumn();
var values = ss2.getRange(5, r1+2, 14, 1).setValues(values);
}
function addtodescriptionbottom(){
var ss1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Генер");
var ss2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Лист14");
var values = ss1.getRange(1, 1, 14, 1).getValues();
Logger.log(values);
var r = ss2.getLastRow();
var r1 = ss2.getLastColumn();
var values = ss2.getRange(r+5, 3, 14, 1).setValues(values);
}
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question