0

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

  };
Ryu Loa
  • 1
  • 1

0 Answers0