title: How to make a copy of a single sheet and save it to a folder in google sheets
body: <p>I'm currently working on a problem I have where I have around 20 different sheets that I'm working with. With each sheet, I've created a button that says "export" that will save the single sheet (if I can figure it out) to a specified folder. I then have a script that clears the sheet so that it's new again (That works great!). I'm using this in our brewery to take the date of beers in tanks and when the tank is empty, the data is then stored for future reference. </p>
  
  <p>So, as of now, the code work pretty much as I'd like it to, but it's saving all of the sheets as one file and now only exporting the sheet that I'm currently looking at. </p>
  
  <p>Any help on this would be greatly appreciated.</p>
  
  <p>I've tried a couple different codes and this is as close as I've gotten.</p>
  
  <pre><code>function createCopy() {
    var myValue = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange("A29").getValue();
    var destinationFolder = DriveApp.getFolderById("&lt;&lt;google drive folder&gt;&gt;");
    DriveApp.getFileById(SpreadsheetApp.getActiveSpreadsheet().getId()).makeCopy(myValue,destinationFolder);
  }
  </code></pre>
  
  <p>If all goes well, it will save a single sheet to my destination folder.</p>