Results 1 to 2 of 2
Thread: Auto Filter (any)
2005-07-01, 11:08 #1
- Join Date
- May 2003
- Thanked 0 Times in 0 Posts
Auto Filter (any)
I very often use the auto filter to hide certain rows in my worksheets, but is there a way to do the same with columns? Thanks.
2005-07-01, 11:29 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: Auto Filter (any)
No there is no built-in way. The closest is to "Group/Outline" by columns, but I do not think this is what you want. You can hide/unhide columns depending on how they are grouped, but it does not work like autofilter on individual rows to fileter columns like an autofilter would.
Create your own code to check the columns and then hide them (could be very cumbersome)
Redesign the database to more conventional: fields as the columns, data in rows. and then use the conventional filtering:
Transpose your database so the columns are rows and rows are columns
Other redesign options.
If you want to provide some details of your current design and how you plan on using the data (inputting desires and output needs) we can offer some suggestions.