Guest User

Untitled

a guest
Apr 25th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. function onEdit() {
  2.  
  3. var OriginalsheetName = "MODEL";
  4.  
  5. var OriginalcolumnNum = 5;
  6. var valueToWatch = "car, lorry, van";
  7. var sheetNameToMoveTheRowTo = "Sheet9";
  8.  
  9. var ss = SpreadsheetApp.getActiveSpreadsheet();
  10. var sheet = SpreadsheetApp.getActiveSheet();
  11. var range = sheet.getActiveCell();
  12.  
  13.  
  14. if (sheet.getName() == OriginalsheetName && range.getColumn() ==
  15. OriginalcolumnNum && range.getValue() == valueToWatch) {
  16.  
  17. var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
  18. var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
  19. sheet.getRange(range.getRow(), 1,
  20. sheet.getLastColumn()).moveTo(targetRange);
  21.  
  22. function Copy() {
  23.  
  24. var sss = SpreadsheetApp.openById('xxx');
  25.  
  26. var ss = sss.getSheetByName('MODEL');
  27.  
  28. var range = ss.getRange('A1:E163');
  29. var data = range.getValues();
  30.  
  31.  
  32. var tss = SpreadsheetApp.openById('1yys-jh-56octftdi5gxqUP_dy6LQze5-
  33. taypU2cmos0');
  34.  
  35. var ts = tss.getSheetByName('Sheet14');
  36.  
  37. ts.getRange(1, 1, data.length, data[0].length).setValues(data);
  38.  
  39.  
  40. }
Add Comment
Please, Sign In to add comment