| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide rows based on cell data
On Jul 27, 1:56*pm, Munchkin
wrote: My spreadsheet shows 6 different department's file records. *Colum J specifies Dept A, Dept B, Dept C, etc. * I'd like to create a macro button for each Dept that would show just thier records and hide the others, but I don't know how. *Can anyone help? Hi Munchkin, why not use Excel's Auto Filter? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Rows based on value of a cell | Excel Programming | |||
| Hide/Show Rows based on Cell Value with Data Validation | Excel Programming | |||
| hide rows based on cell value | New Users to Excel | |||
| hide rows based on value in cell | Excel Discussion (Misc queries) | |||
| Macro to hide rows based on a zero value in a particular cell | Excel Programming | |||
![Ron[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
