Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function copyInfo()
- {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var copySheet = ss.getSheetByName("Sheet4");
- var pasteSheet = ss.getSheetByName("Sheet5");
- // get source range
- var source = copySheet.getRange('A2:L');
- // get destination range
- var destination = pasteSheet.getRange(pasteSheet.getLastRow()+1,1,5,12);
- // copy values to destination range
- source.copyTo(destination);
- // clear source values
- source.clearContent();
- }
Add Comment
Please, Sign In to add comment