Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering
Hi. I use AutoFilter a lot to filter based on what information is contained
in a column. Is it possible to filter based on rows as well? For example, show only columns that have this value in this row. Thanks. Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering
Chris,
There is no built-in functionality to do that. You could use a macro, if you are comfortable with that - for example, if you only wanted to show columns B to H if their value on the activecell's row is Show Me, then you could use Sub TryNow() Dim myC As Range For Each myC In Intersect(ActiveCell.EntireRow.Cells, Range("B:H")) If myC.Value = "Show Me" Then myC.EntireColumn.Hidden = False Else myC.EntireColumn.Hidden = True End If Next myC End Sub HTH, Bernie MS Excel MVP "CMD" wrote in message ... Hi. I use AutoFilter a lot to filter based on what information is contained in a column. Is it possible to filter based on rows as well? For example, show only columns that have this value in this row. Thanks. Chris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering
Hi Chris
Debra Dalgleish has a downloadable example at http://www.contextures.com/AdvFilterStateNum.zip -- Regards Roger Govier "CMD" wrote in message ... Hi. I use AutoFilter a lot to filter based on what information is contained in a column. Is it possible to filter based on rows as well? For example, show only columns that have this value in this row. Thanks. Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering | Excel Discussion (Misc queries) | |||
Filtering | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
filtering | Excel Discussion (Misc queries) |