copy data from one sheet to another in google app script and append a row, one small issue

by

You can copy whole range at once using copyTo, so your function could be rewritten as:

function copyInfo() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var copySheet = ss.getSheetByName("Copy");
  var pasteSheet = ss.getSheetByName("Paste");

  // get source range
  var source = copySheet.getRange(2,2,12,2);
  // get destination range
  var destination = pasteSheet.getRange(pasteSheet.getLastRow()+1,2,12,2);

  // copy values to destination range
  source.copyTo(destination);

  // clear source values
  source.clearContent();
}

More Related Contents:

  1. Determining the last row in a single column
  2. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  3. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  4. Google Sheets OnEdit() – You do not have permission to call a service
  5. Detect user inserting row or column in a google spreadsheet and reacting in a script
  6. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  7. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  8. Google app scripts: email a spreadsheet as excel
  9. Is there a way to keep two sheets synchronized?
  10. Selecting the last value of a column
  11. Moving Files In Google Drive Using Google Script
  12. How to get onFormSubmit to trigger automatically?
  13. Copying a spreadsheet copies all linked files as well
  14. onEdit simple trigger never seems to be triggered
  15. “SpreadsheetApp.getUi() cannot be called from this context”
  16. How to get filtered values from Filter after using setColumnFilterCriteria?
  17. Protect ranges with google apps script
  18. GAS “On edit” trigger not running when edited from API
  19. How to access new ‘in-cell-image’ from google apps script?
  20. How to convert a Google Sheets-File to an Excel-File (XLSX)
  21. Difference between getValue() and getDisplayValue() on google app script
  22. How to allow onEdit function to affect protected cell in a Google Sheet?
  23. Creating and Sending sheets in the same function
  24. How do I know if spreadsheet cells are merged using google apps script
  25. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  26. How to prefill Google form checkboxes?
  27. Google apps script error: “You do not have permission to call protect” [duplicate]
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment