Advertisement
mentoly

Append Data to First Empty Row

Feb 18th, 2020
488
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.49 KB | None | 0 0
  1. function appendData() {
  2.  
  3.   var ss = SpreadsheetApp.getActiveSpreadsheet();
  4.   var source = ss.getRange("rejoin!A2:E51");
  5.   var destSheet = ss.getSheetByName("cache");
  6.   destSheet.appendRow(source.getValues()[0]);
  7.   destSheet.appendRow(source.getValues()[0]);
  8.   destSheet.appendRow(source.getValues()[0]);
  9.   destSheet.appendRow(source.getValues()[0]);
  10.   destSheet.appendRow(source.getValues()[0]);
  11.   destSheet.appendRow(source.getValues()[0]);
  12.   destSheet.appendRow(source.getValues()[0]);
  13.  
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement