Filtering

[Neil Pearce]

Dear all,

Using the autofilter option it is possible to hide rows that contain
irrelevant data to the selected filter. Is there a similar tool to hide
uncessary columns?


Thanking-you in advance,

Neil

 

[John Bundy]

I'll be interested to see if anyone has a way. As a possible alternative, try
to copy and paste special Transpose on another sheet, then autofilter it.
This has limitations as you can only have 256 columns so if you have a lot of
data it wont work.

 

[Max]

One link for horizontal filter - 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
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---