title: How to sort rows on column A in ListObject VBA with parameter in Column B
body: <p>I've got a  table in Excel which is filled through a Listobject macro from a database.</p>
  
  <p>I am able to sort the table through following code:</p>
  
  <pre><code>'Sort on projecttabel
  Dim lo As Excel.ListObject
  
  Set lo = Plan.ListObjects(1)
  With lo
  .Sort.SortFields.Clear
      .Sort.SortFields.Add _
          Key:=Range("Table_appnlvd03_nkmgo_report_NKMGO_Report__KHNS_EFTTS_KPI32[klant]"), SortOn:=xlSortOnValues, Order:=xlAscending, _
          DataOption:=xlSortNormal
      .Sort.SortFields.Add _
          Key:=Range("Table_appnlvd03_nkmgo_report_NKMGO_Report__KHNS_EFTTS_KPI32[Status]"), SortOn:=xlSortOnValues, Order:=xlAscending, _
          DataOption:=xlSortNormal
      .Sort.SortFields.Add _
          Key:=Range("Table_appnlvd03_nkmgo_report_NKMGO_Report__KHNS_EFTTS_KPI32[RFO plandatum]"), SortOn:=xlSortOnValues, Order:=xlDescending, _
          DataOption:=xlSortNormal
      .Sort.SortFields.Add _
          Key:=Range("Table_appnlvd03_nkmgo_report_NKMGO_Report__KHNS_EFTTS_KPI32[Uitvoeren montage plan start]"), SortOn:=xlSortOnValues, Order:=xlDescending, _
          DataOption:=xlSortNormal
  
      With .Sort
          .Header = xlYes
          .MatchCase = False
          .Orientation = xlTopToBottom
          .SortMethod = xlPinYin
          .Apply
      End With
  End With
  </code></pre>
  
  <p>The "Status" has multiple integer values ranging from 1 to 100.
  What i would like to do is to is sort rows based on their status AND another column. The problem I encounter is that the "second column"to sort on is different for each status.</p>
  
  <p>What i Would like to create is a "Gant" like table where the different date columns are sorted Descending for each status. For example (DD-MM-YYYY)</p>
  
  <pre><code>[Status]   [date1]              [date2]         [date3]
  1         **10-01-2015**       12-02-2015        31-03-2015      
  1         **09-01-2015**       14-02-2015        10-03-2015          
  1         **08-01-2015**       06-02-2015        05-03-2015  
  1         **07-01-2015**       18-02-2015        28-03-2015  
  2         17-01-2015       **15-02-2015**        10-03-2015  
  2         27-01-2015       **14-02-2015**        10-03-2015  
  2         04-01-2015       **13-02-2015**        16-03-2015  
  2         31-01-2015       **05-02-2015**        10-03-2015  
  5         18-01-2015       12-02-2015        **30-03-2015**  
  5         31-01-2015       18-02-2015        **27-03-2015**  
  5         17-01-2015       04-02-2015        **26-03-2015**  
  5         07-01-2015       27-02-2015        **08-03-2015**  
  5         09-01-2015       24-02-2015        **03-03-2015**  
  </code></pre>
  
  <p>etc. Is this possible?</p>