title: Copying & pasting drop down lists clears cells
body: <p>So I'm quite new to script, and I've got some working dynamic dependent drop down lists. When I clear a cell in column A, it clears the cell directly to the right of it, which is great.</p>
  <p>However, when I copy and paste a row, it clears the cell to the right of column A. My question is: <strong>Is there a way to make a row &quot;copy &amp; paste-able&quot;, so it doesn't clear column B when pasting?</strong></p>
  <p>Here are some images of what I'm describing:
  [1]: <a href="https://i.stack.imgur.com/F0xOg.png" rel="nofollow noreferrer">https://i.stack.imgur.com/F0xOg.png</a>
  [2]: <a href="https://i.stack.imgur.com/geHuu.png" rel="nofollow noreferrer">https://i.stack.imgur.com/geHuu.png</a></p>
  <p>Lastly, here's the script that I'm using:</p>
  <pre><code>function onEdit(){
      var tabLists = &quot;Exercise Index&quot;;
      var spreadsheet = SpreadsheetApp;
      var activeSheet = spreadsheet.getActiveSpreadsheet().getActiveSheet();
      var data = spreadsheet.getActiveSpreadsheet().getSheetByName(tabLists);
      
      var activeCell = activeSheet.getActiveCell();
      
      if(activeCell.getColumn() == 1 &amp;&amp; activeCell.getRow() &gt; 3 &amp;&amp; activeSheet.getSheetName().includes(&quot;Week&quot;)){
        
        activeCell.offset(0, 1).clearContent().clearDataValidations();
        
        var makes = data.getRange(1, 1, 1, data.getLastColumn()).getValues();
        
        var makeIndex = makes[0].indexOf(activeCell.getValue()) + 1;
        
        if(makeIndex != 0){
        
            var validationRange = data.getRange(2, makeIndex, data.getLastRow());
            var validationRule = spreadsheet.newDataValidation().requireValueInRange(validationRange).build();
            activeCell.offset(0, 1).setDataValidation(validationRule);
      
        }  
          
      }
      
    }
  </code></pre>
  <p>Copy of the google sheet: <a href="https://docs.google.com/spreadsheets/d/1OrDTJiAlVJRU5tKCA55CoVgnT83_k8n_yz9BkWYpZ_0/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1OrDTJiAlVJRU5tKCA55CoVgnT83_k8n_yz9BkWYpZ_0/edit?usp=sharing</a></p>
  <p>Thanks in advance!</p>