You could look at View|Custom views (xl2003 menu system)
or provide a macro that hides/shows columns the way you like.

wrote:

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.

--

Dave Peterson