Hide Columns that do not = drop down menu selection

I have a table with data that is sorted by the information I want to present in the columns and the data I want to filter by is on the top row (C2:W2). I want to be able to hide the columns that do not equal a drop down box I have. Is VBA the only way to accomplish this?

Thanks,

I sure can! So I just remade the work book with random data to post an example. Little explanation: I have the headers in B5:B9 that I want to be able to see and filter based on the combo box in B3 the columns C3:W2 based on the value that is equal to the combo box. Just want to hide the column if it's not equal to the selected value.

Sample.xlsx

Hope that makes sense

Maybe:

Please Login or Register  to view this content.

GeneralDissaray and John H. Davis,

Thanks you so much, I used your code GeneralDissaray and it worked wonderfully just as I needed! thank again for the help! As always Excel help forum community made my day so much easier!

Cheers!

Sorry one more thing! If I wanted to add an option in the drop down to un hide all to view all where would I add that? If the drop down menu item=8 unhide all rows in range

For my suggestion:

Please Login or Register  to view this content.

Perfect! Thanks again!