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

You could use filtering and Macro's but it would be a lengthy process to
build. Probably a User Form would be the best way to do this, however this
is also not a simple process.

The following links may be of help:
http://msdn.microsoft.com/en-us/library/aa192538.aspx
http://www.contextures.on.ca/excelfiles.html#DV0017

I also had a similar exercise which I posted to this forum on the 23rd
Titled "Multiple Selection Combo Box" Dave Peterson posted a very helpful
response with some very effective VB Code.

Hope this helps



"brumanchu" wrote:

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