filtering

  • Thread starter Thread starter CMD
  • Start date Start date
C

CMD

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
 
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
 
Back
Top