title: Google script to copy sheet in spreadsheet to new spreadsheet and name new spreadsheet after specific cell
body: <p>I have a google spreadsheet with multiple sheets within it, I would like to copy each individual sheet into a new spreadsheet and to have the new spreadsheet named after text in a specific cell. I am happy to run the script multiple times so I figured to have it copy the active sheet.</p>
  
  <p>i.e.
  What I have =
  Spreadsheet called "Colours" - Sheet 1="red", Sheet 2= "blue", Sheet 3= "yellow", etc.</p>
  
  <p>What I want =</p>
  
  <p>Spreadsheet called "Red". Spreadsheet called "blue", Spreadsheet called "yellow"</p>
  
  <p>So far I have this script but its telling me "Script function not found: saveAsSpreadsheet For more information"</p>
  
  <pre><code>function copyDocument() {
  var ss = SpreadsheetApp.getActiveSpreadsheet(); // Get current active spreadsheet.
  var sstocopy = ss.getActiveSheet(); // Get spreadsheet with DriveApp.
  var sheet = ss.getActiveSheet(); // Get current active sheet.
  var sheet_name = sheet.getRange("i2").getValue(); // Get the value of cell B1, used to name the new spreadsheet.
  var folder = DriveApp.getFolderById("xxxxxxxxxxxxx"); // Get the ID of the folder where you will place a copy of the spreadsheet.
  sstocopy.makeCopy(sheet_name,folder); // Make a copy of the spreadsheet in the destination folder.
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>