I think you would need a macro to do this - there is no built-in
feature to allow you to do it.

Pete

On Oct 24, 1:24 am, 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.