Combo box to pull certain rows from a pivot table

[illsonds]

Hello! I have an orders report where each row contains all the details of each order (Order ID #, customer information, products purchased, order totals etc.). If a specific customer has ordered from us 3 times, their information would be contained in the Orders report 3 times, once for each order. On a seperate tab, I have a pivot table pulling the customers name in column A, and "count of Order ID" in column B. Th result of this pivot table shows me how many orders have been placed by each distinct customer. I have filters in the pivot table for "Order Month". So, for example, when the filter is set to May, the pivot table returns the names of all customers who ordered in May in column A along with how many orders they placed in May in column B.

I need to get lists of customers segmented by how many times they've ordered in a given month. 3 orders in a month are Great customers, 2 in a month are Good customers, and 1 in a month are Ok customers.

The two ways I could envision this happening are 1) Three separate sheets (Great, Good, Ok), that reference the pivot table and populates a list of the appropriate customers based on the "count of Order ID" field. OR 2) A combo box where I can select Great, Good, Ok, and it will populate a list of the appropriate customers for that month. When I change the Order Month filter in the pivot table, I would like the sheets to still populate correctly for that given month.

Any ideas?

Thanks!

[k64]

Can't you just make a column that has a formula like

=IF(A1>50,"Great",IF(A1>10,"Good","OK"))

and then filter by that column?