Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows via Pulldown
Hello all. I have a data sheets with lots of personnel info. I would
like to create 2 pulldown menus that will hide rows. In column A I have department. In column B I have status. How can I have the user select a department from the "Department" pulldown, and a status from the "status" pulldown and have the data sheet hide all rows OTHER than the selections? I guess I would also need an "All" selection for each of the categories. Essentially it sounds like an autofilter, but for the executive staff I need something with a simpler front end. Thanks for any and all help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Specify which rows to NOT hide, and have excel hide the rest | Excel Programming | |||
multiple choices from pulldown... how to apply to several pulldown | Excel Programming | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions |