title: Move (Copy) value of a cell based on dropdown value in Google Sheets
body: <p>I'm trying to create a basic CRM using Google Sheets that holds all the client's data in one sheet and shows which part of the deal stage they're in on another sheet. Below is an example of what I mean.</p>
  
  <p>Sheet 1:</p>
  
  <pre><code>Name |  Email  |  Deal Stage |
  Ian     ian@..  &gt;&gt;Pre-launch &lt;&lt; dropdown list 
  Ken     ken@..  &gt;&gt;Pre-launch &lt;&lt; dropdown list 
  Dan     dan@..  &gt;&gt;Out-Reach  &lt;&lt; dropdown list
  Ben     ben@..  &gt;&gt;Call Booked&lt;&lt; dropdown list
  </code></pre>
  
  <p>Sheet 2:</p>
  
  <pre><code>Pre-Launch | Out-Reach | Brochure Sent | Call Booked |
  Ian          Dan                         Ben
  Ken
  </code></pre>
  
  <p>I'm looking to create a script that fires <code>onEdit</code> of any item in the dropdown cells. Is this possible, and what's the cleanest way?</p>
  
  <p>I have created this <a href="https://docs.google.com/spreadsheets/d/180-4PE9y325xxSyWyxX1eRpE0P2QIiXtzZ0rLzDi-9g/edit?usp=sharing" rel="nofollow noreferrer">Example Sheet</a> which only includes the feature in question. </p>