Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Dec 7th, 2018 60 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. function onEdit(e) {
  2. var spreadsheet = SpreadsheetApp.getActive();
  3. var ss = SpreadsheetApp.getActiveSpreadsheet();
  4. var sheet1 = ss.getSheetByName("Sheet 1");
  5. var cell2 = sheet1.getRange('H11');      
  6. var x= cell2.getValue();
  7.  
  8. if(x == true)
  9.  {
  10. spreadsheet.getRange('E11').activate();
  11. spreadsheet.getRange('D11').moveTo(spreadsheet.getActiveRange());
  12. }
  13.  
  14. else if(x == false)
  15. {
  16. spreadsheet.getRange('D11').activate();
  17. spreadsheet.getRange('E11').moveTo(spreadsheet.getActiveRange());    
  18. }
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top