Hello,

To start off, I have never used VBA before, so bear with me. I am trying to create a way to sort data (similar to the generic filter) but through drop downs. I attempted to use this thread :http://www.excelforum.com/excel-gene...lter-data.html but could not seem to edit it to fit my scenario.

I have attached a file (at least I believe I did) of some of what I need to sort. I would like to sort based on data in columns C-L, first sorting by hand, then capacity, then heat etc. I would like it so they could just pick the capacity, it filter out the values, then pick the heat, and so on and so forth.

Book6.xlsm

Let me know if you can do this,
J