0
votes

I am trying to copy a range from sheet 'Full' and paste the values only to a new sheet, 'Dump'. While the macro below does its action once, I am regenerating the original data range (Full), so I want to copy that new set and append to the same output page, indexed down to a blank row and keeping the first pasted data. Also then to do this 100 times. The recoded macro is below, and I need to understand the script to add in to;

  • repeat the copy/paste function 100 times, and also
  • offset the paste range by a set number of rows.

Sorry, genuine newbie at editing google sheet macros. The Excel macro I use doesn't translate over. Appreciate any answers you have.

```function xmacro() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('A1').activate();
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Full'), true);
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Dump'), true);
  spreadsheet.getRange('Full!BK3:BT34').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);```

};