Answer the question
In order to leave comments, you need to log in
How to move all sheets from one Google spreadsheet to another?
There are 2 table files, each with 10 sheets, how quickly from one table file, transfer all 10 sheets to another?
Answer the question
In order to leave comments, you need to log in
1) Use IMPORTRANGE (table_key; range)
2) Right-click on the sheet label: Copy to... > Existing table
3) Write a script: iterates over all sheets, copies the sheet to a new table.
const id="тут_id_таблицы-приёмника";
let destination = SpreadsheetApp.openById(id)
let ss = SpreadsheetApp.getActiveSpreadsheet();
let sheets = ss.getSheets();
for (var sheet in sheets){
sheets[sheet].copyTo(destination)
};
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question