tallying_sheet.gs

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
  ui.createMenu('Main Menu')
      .addItem('Create Tallying Sheet', 'copy2')

      .addToUi();
}



//function to copy tallying to generator
function copy2() {

var folder=DriveApp.getFolderById("1DsAuDj0ouN8xIV1YhlUyMurJWjsy-DgY");
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = ss.getSheets()[0,1];
 var cellWithFileName = ss.getRange("B4");
 var name = cellWithFileName.getValue();
var file=SpreadsheetApp.create(name);

 var fileID = file.getId()
var copyFile=DriveApp.getFileById(fileID);
 var destination = DriveApp.getFileById(fileID)
folder.addFile(copyFile); //copies file in folder we want: file is blank at this time

DriveApp.getRootFolder().removeFile(copyFile); //removes copied file from root

var newsheet = ss.getSheetByName("Tallying").copyTo(file);
var copyOnlyRange1 = ["A1:B7"];
//var copyOnlyRange3 = ["A9:D12"];
//var copyOnlyRange2 = ["C36:B359"];

var srcrng1 = ss.getRange(copyOnlyRange1);
var values1 = srcrng1.getDisplayValues();
//var srcrng2 = ss.getRange(copyOnlyRange2);
//var values2 = srcrng2.getDisplayValues();
//var srcrng3 = ss.getRange(copyOnlyRange3);
//var values3 = srcrng3.getDisplayValues();

newsheet.getRange(srcrng1.getA1Notation()).setValues(values1);
//newsheet.getRange(srcrng2.getA1Notation()).setValues(values2);
//newsheet.getRange(srcrng3.getA1Notation()).setValues(values3);
}