title: activex-combobox for name column in excel
body: <p>I have an excel sheet I use to record casual worker data.</p>
  
  <p>Out of 6 columns, the options to which can be chosen through data validation do not change and are therefore not a problem.(range of days worked/Overtime, etc).</p>
  
  <p>The one thing I need help with is the name column where I would like an activeX combobox so I can make use of autofill and have the ability to add new names all the time.</p>
  
  <p>Unlike data validation which can be dragged and copied down a range of cells (I usually have no more than 100 casual workers), I am unsure how to do this with a combobox so every new row of my name column contains that combobox. Please advise.</p>