Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- var spreadsheet = SpreadsheetApp.getActive();
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss.getSheetByName("Sheet 1");
- var cell2 = sheet1.getRange('H11');
- var x= cell2.getValue();
- if(x == true)
- {
- spreadsheet.getRange('E11').activate();
- spreadsheet.getRange('D11').moveTo(spreadsheet.getActiveRange());
- }
- else if(x == false)
- {
- spreadsheet.getRange('D11').activate();
- spreadsheet.getRange('E11').moveTo(spreadsheet.getActiveRange());
- }
Add Comment
Please, Sign In to add comment