Guest User

Untitled

a guest
Dec 18th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. function copyInfo()
  2. {
  3. var ss = SpreadsheetApp.getActiveSpreadsheet();
  4. var copySheet = ss.getSheetByName("Sheet4");
  5. var pasteSheet = ss.getSheetByName("Sheet5");
  6.  
  7. // get source range
  8. var source = copySheet.getRange('A2:L');
  9.  
  10. // get destination range
  11. var destination = pasteSheet.getRange(pasteSheet.getLastRow()+1,1,5,12);
  12.  
  13. // copy values to destination range
  14. source.copyTo(destination);
  15.  
  16. // clear source values
  17. source.clearContent();
  18. }
Add Comment
Please, Sign In to add comment