Hello,
I have a list of activities by department, and I want to show only the top
10 highest savings across user input defined categories.

For example, one column has 7 different department names, other columns
contain data like activity name, responsibility, start date, etc. I would
like to set up a series of check boxes that mgmt could select for the 7
departments, then return the top 10 activities based on a savings column.
This would allow them to exclude one or more departments from the project
list.

Is this the right use of filtering & macros, or is there a better way to
achieve the same results? the data must be moved to a separate sheet in the
workbook where other summary info is rolled up.

I'm using Excel 2003.

thanks for your help