View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kcleere kcleere is offline
external usenet poster
 
Posts: 3
Default Need help hiding/unhiding column based on autofilter selection in a different column


I have a task before me I need help with.

I have a customer (My Boss) who wants to hide 2 columns in a
spreadsheet automatically when a specific text is selected from an
"autofilter list" in a different column. Then, show the hidden column
again when any other text is selected in the filter list column.

It's not obvious to me how to do this or if it can be done in Excel.
I'd appreciate any input you have here.

Thank you in advance for any input you have.