Function copySelectionToSheet

GettingandSettingData.js:10–18

()

}

function copySelectionToSheet(){
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    const sheet = ss.getActiveSheet();
    const range = sheet.getActiveRange();
    const data = range.getValues();
    const newSheet = ss.insertSheet();
    const newRange = newSheet.getRange(1,1,range.getNumRows(),range.getNumColumns());
    newRange.setValues(data);
}

function copyToSheet(){
  const ss = SpreadsheetApp.getActiveSpreadsheet();