Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List sort - filter macro based on check box
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter based on list | Excel Discussion (Misc queries) | |||
List, Filter Sort? | Excel Discussion (Misc queries) | |||
Filter or sort a macro result | Excel Discussion (Misc queries) | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Can one cell hold multiple check boxes (and then sort based off e. | Excel Discussion (Misc queries) |