Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit() {
- var OriginalsheetName = "MODEL";
- var OriginalcolumnNum = 5;
- var valueToWatch = "car, lorry, van";
- var sheetNameToMoveTheRowTo = "Sheet9";
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = SpreadsheetApp.getActiveSheet();
- var range = sheet.getActiveCell();
- if (sheet.getName() == OriginalsheetName && range.getColumn() ==
- OriginalcolumnNum && range.getValue() == valueToWatch) {
- var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
- var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
- sheet.getRange(range.getRow(), 1,
- sheet.getLastColumn()).moveTo(targetRange);
- function Copy() {
- var sss = SpreadsheetApp.openById('xxx');
- var ss = sss.getSheetByName('MODEL');
- var range = ss.getRange('A1:E163');
- var data = range.getValues();
- var tss = SpreadsheetApp.openById('1yys-jh-56octftdi5gxqUP_dy6LQze5-
- taypU2cmos0');
- var ts = tss.getSheetByName('Sheet14');
- ts.getRange(1, 1, data.length, data[0].length).setValues(data);
- }
Add Comment
Please, Sign In to add comment