copy and paste with google spreadsheet script

Question

I would like to modify the script shown below, so that if re-run, it does not overwrite pre-existing data, but instead writes the rows under it.

(I use the google spreadsheet)

moveValuesOnly fonction () {
var ss = SpreadsheetApp.getActiveSpreadsheet ();
var source = ss.getRange ("Sheet1 F1: H3 ');
source.copyTo (ss.getRange ("Feuil2 A1! '), {contentsOnly: true});
source.clear ();
}

score 13 · Accepted Answer · answered Sep 09 '13 at 16:52

13

This version will find the first empty row in the destination sheet, and copy the source data so it starts there.

function moveValuesOnly () {
  var ss = SpreadsheetApp.getActiveSpreadsheet ();
  var source = ss.getRange ("Sheet1!F1:H3");
  var destSheet = ss.getSheetByName("Feuil2");
  // Déterminer l'emplacement de la première ligne vide.
  var destRange = destSheet.getRange(destSheet.getLastRow()+1,1);
  source.copyTo (destRange, {contentsOnly: true});
  source.clear ();
}

answered Sep 09 '13 at 16:52

Mogsdad

44,709
21
151
275

1

How can I use this for specific columns? so lets say only column 2, 4 and 5 ? – MSD Dec 02 '16 at 00:08
this is removing the data from the original spreadsheet. How do I just copy the info? – DBWeinstein Jun 01 '21 at 03:16
Delete "source.clear ();" from the script – Marcelo Meza Mar 10 '23 at 10:55

copy and paste with google spreadsheet script

1 Answers1

Linked