I am trying to copy data from Tab ERO3 fields E3:F11 to the end of Tab Recap. The data on ERO3 will change daily but i need to data pasted in recap to not change when the data in ERO3 changes. The Data transfer is triggered by clicking on a checkbox on the recap tab in B1.
Here is what I have been trying.
function copPas() {
var as= SpreadsheetApp.getActiveSpreadsheet();
var data1= as.getSheetByName("ERO3"); // Copy from this sheet
var data2= as.getSheetByName("Recap"); // Paste to this sheet
var range= data1.getRange("E3:F11"); // Data range to copy
range.copyTo(data2.getRange(sheet.getLastRow()+1)); // Where to paste the data
};