title: Automatically change dropdown value when source value changed
body: <p>I've seen a few things related to this, but haven't come across anything that worked.  I have an Excel workbook with two worksheets, named "Roster" and "July".  On the Roster worksheet, in cells E8:E507, I have a range of values named "Students".  On the July worksheet, in cell C12, I have a dropdown list created through data validation and naming the Students range as the source.  All of this works fine.</p>
  
  <p>My problem is that if I select a value in the dropdown menu, and then change the source value in the Roster worksheet, it doesn't automatically reflect that change back on the July worksheet.</p>
  
  <p>Is there a macro that would make any dropdowns refresh automatically when their source ranges are changed?</p>
  
  <p>Thanks.</p>