title: Excel: Creating a dropdown using a list in another sheet?
body: <p>Let's say in Sheet1 I have a list of codes ("AA", "QF", etc).</p>
  
  <p>In Sheet2, I want a particular column to have cells that, when you  click them, have a dropdown that consists of values from the code-list on Sheet1. (so you could fill the value of the cell with AA, QF, etc).</p>
  
  <p>Is this doable?</p>