Copy Single Sheet From One Spreadsheet to New Spreadsheet

Question

I have the following script that copies a Google Spreadsheet to a new folder. I would like to modify it so that rather than copying the entire spreadsheet it only copies the second sheet of the spreadsheet to the new file. I have spent considerable time adding and modifying variables and can't seem to accomplish it.

//Archive the Sheet
   var sheet = SpreadsheetApp.getActiveSpreadsheet();
   var lastrow = sheet.getLastRow();
   var range = sheet.getRange('A1:N' + (lastrow) + '');
   var date = new Date();
   var formattedDate = Utilities.formatDate(date, "CST", "MM-dd-yy")
   sheet.setNamedRange('Archive', range);
   var TestRange = sheet.getRangeByName('Archive').getValues(); 
   Logger.log(TestRange); 
   var destFolder = DriveApp.getFolderById("0Byeq4rjTXxVzVzJyQWZxY2pyODA"); 
   DriveApp.getFileById(sheet.getId()).makeCopy(formattedDate, destFolder); 

Any suggestions?

Answer 1

Use copyTo(spreadsheet) method. If you want that the new spreadsheet has only the copied sheet, delete the default sheet by using deleteSheet(sheet).