title: Excel VBA: sorting a table featuring cells with drop-down lists
body: <p>Let's say I have an Excel table featuring one column ("B" for example) in which every cell has a different drop-down list for validation. My application is such that different cells in "B" may contain different items in their corresponding drop-down lists. I want to sort my table using a different column as the key, for example column "A", which contains dates, in ascending order. </p>
  
  <p>My problem is that Excel's Sort function (apparently) does not include validation lists. Therefore, after sorting, each cell in "B" will most likely end up with the wrong drop-down list. Can somebody suggest a simple way to implement the sorting in VBA such that it includes the drop-down lists? I know I could try sorting the table first and then populating "B" with the drop-downs, but I want to avoid that option if possible.</p>