There is data in cells B7 and B8 (clearly in the figure). Old data in cells B1 & B2
What script will help write this data to cells B1 and B2? (result in the figure) Script result

    1 answer 1

    Use copyTo

    In your case, it is:

    SpreadsheetApp.getActiveSheet().getRange("B7:B8").copyTo(SpreadsheetApp.getActiveSheet().getRange("B1:B2"))