-1

I would like to move a sheet ("HeaderSheet") from one workbook ("HeaderSpreadsheet") to another workbook ("ReportSpreadsheet"). Is it possible??

I tried the following without success:

var HeaderSpreadsheet = SpreadsheetApp.openByUrl('Url_1')
var ReportSpreadsheet = SpreadsheetApp.openByUrl('Url_2')
  
HeaderSheet = HeaderSpreadsheet.getSheetByName("Header")  
  
ReportSpreadsheet.insertSheet('Data', 1, {template: HeaderSheet})

Alternatively, could I copy the content from the Header workbook to the Report one?

Thank you very much for your help

Nicola Trenti
  • 44
  • 12
  • Did you even look in the Apps Script documentation?? Doing research is a required part of asking a question. – tehhowch Jun 21 '18 at 14:31

1 Answers1

0

I found my question was already solved.

This may be useful:

Google Apps Script, copy one spreadsheet to another spreadsheet with formatting

Nicola Trenti
  • 44
  • 12