Is there anyway to filter horizontally in Excel, rather than veritcally?

Amanda,

Only with VBA code (macro or event) used to hide the columns that don't meet your criteria. For
example:

Sub HideX()
Dim myC As Range
For Each myC In Range("B2:H2")
myC.EntireColumn.Hidden = (myC.Value = "X")
Next myC
End Sub

Sub UnHide()
Cells.EntireColumn.Hidden = False
End Sub


HTH,
Bernie
MS Excel MVP


"Amanda L" wrote in message
...
Is there anyway to filter horizontally in Excel, rather than veritcally?

Maybe you can group the columns.

Select a column(s)
Data|Group and Outline|Group.
(xl2003 menus)

You end up with the outlining symbols at the top. It's not the same as
filtering, though.

Maybe you could define custom views that hide/show the columns you want.
View|Custom Views
(also xl2003 menus)


Amanda L wrote:

Is there anyway to filter horizontally in Excel, rather than veritcally?

--

Dave Peterson

"Amanda L" wrote:
Is there anyway to filter horizontally in Excel, rather than vertically?

You could also try Andrew Engwirda's page at:
http://blog.livedoor.jp/andrewe/archives/50283818.html
There's a d/l link for a sample file on the page
(Horizontal Filter)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---