title: Excel copying value with VBA corresponding to a key after changing a cell
body: <p>I am trying the folowing since a few days but due to my lack of VBA skills don't get it working.</p>
  
  <p><strong>Scenario:</strong></p>
  
  <ol>
  <li>User: Selects a value from dropdown list  (cells allow only a list
   defined in another sheet).</li>
  <li>Code: Copy the value left to the appropriate  list value. (This is a list of names.)</li>
  <li>Code: Paste the value into a specific field in sheet one.</li>
  </ol>
  
  <p><strong>Example:</strong><br>
  The user is picking the value "Team One" from a dropdownlist in A1 in sheet one. This list is defined on sheet two. Next to each item of the list on sheet two is a cell with a comma separated list of names.
  After the user has picked a team from the dropdown list, the corresponding list of names is copied into the field B1 in sheet one.</p>
  
  <p>This procedure should only be fired when <code>A1</code> is changed.</p>
  
  <p>Hope I could make myself clear. If I finally find the solution myself, I will post it here.</p>
  
  <p>Thank you for reading this.</p>