View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
[email protected] pamacc@gmail.com is offline
external usenet poster
 
Posts: 4
Default Horizontal filtering

On Oct 24, 2:19 am, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi

Take a look at Debra Dalgleish's site.
Debra has created a sample workbook which will hide certain columns,
dependent upon criteria that you enter in a cell. This will give you a good
start to achieve what you want.
The file can be downloaded athttp://www.contextures.com/HideMarkedCols.zip

--
Regards
Roger Govier

wrote in message

oups.com...



I can not figure out how to auto-filter columns to display just the
way auto-filter dynamically filters what rows to display. The only
option I can think of is GROUPING, but that is a far cry from being an
optimal solution. Any suggestions would be appreciated.- Hide quoted text -


- Show quoted text -


I'll give this a look. Thanks.