Filter data using Combo Boxes

I need some help with filtering data using custom filtering driven a number of combo boxes. The combo boxes need to be automatically populated with unique values from data columns.

I have attached a sample workbook with two worksheets named “Data” and “Summary”. In Summary worksheet I have a number of combo boxes.
• First two combo boxes “Start Date” and “End Date” need to be populated with unique values from column "Date" in the “Data” worksheet. This Combo list also need to be in ascending order.
• Other combo boxes need to be populated with unique values from Dest, Category and Country columns from “Data” worksheet.
• When user selects different values in combo boxes and clicks on Calculate button, I want filters on in “Data” worksheet, depending on whatever values are selected in the combo boxes -
- Filter on Date column will be a custom filter – so start date is Greater then or Equal to = combo box1.value And Less then or Equal to = combo box2.value
- Dest, Category and Country filters will be Equal to what ever is selected in other combo boxes.

More data will be added below the existing data so combo boxes should be able to pick up any new values from the new data added.

Then I can use Sub Total functions to summarise data for whatever dimenstions are filtered in the “Data” worksheet.

Hope this all makes sense if not please let me know I will try to explain again.

Many thanks in advance.

GR

Hi

This isn't complete, but it may get you going.

rylo

Thanks for this. It is good but not exactly what I am looking for to achieve the end result. Depending on selections made in combo boxes, I need data to be filtered in the Data sheet. Then I can use worksheet function “Sub Total” to aggregating some other columns to produce summary from filtered data. One thing I missed in my earlier request is that the user may not want to filter all columns. So he or she may only want to summarise data from certain Start Date, to certain End Date for all Destination, for all Categories in a specific country. So in the Dest, Category and Country Combo boxes user should also be able to filter all or non blank rows.

Hope I have not made my request too complex. It seems doable to me. I am sure one of you guys with excellent skills out there will solve this.

Looking forward to hear from someone soon.

Hi everyone,
Can anyone help please.
gsrai31

HI

OK, try this one.

rylo

Thank you. I shall take it from here and try to complete the rest.
If I need some further help with this, I will reply to this thread.
Thanks again.
gsrai31