Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. function copyMultipleSpreadsheet() {
  2.  
  3. var sss = SpreadsheetApp.openById('1FZg6pawRGvxwcH-wQRuw2xM5X5UDT-uf6v4Bq5BqaOQ'); // sss = source spreadsheet
  4. var ss = sss.getSheetByName('Sheet1'); // ss = source sheet
  5.  
  6. //Get full range of data
  7. var SRange = ss.getDataRange();
  8.  
  9. //get A1 notation identifying the range
  10. var A1Range = SRange.getA1Notation();
  11.  
  12. //get the data values in range
  13. var SData = SRange.getValues();
  14.  
  15. var tss = SpreadsheetApp.openById('1hQyOtVSXOMlBJKUeVRneVOYEoBWS599CljpsfP6N2_4'); // tss = target spreadsheet
  16.  
  17. var ts = tss.getSheetByName('Sheet1'); // ts = target sheet
  18.  
  19. //set the target range to the values of the source data
  20. ts.getRange(A1Range).setValues(SData);
  21.  
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement