Hiding columns by selecting from dropdown validation list

[campina]

Hello,

I could use some help, i have created a dropdown list by listing 8 different options. I selected the cell i want the dropdown to be (C2) then selected data validation-> list and selected the 8 different options as the range. So far it works, i now have 8 different options in a dropdown list in cell C2.

In my sheet i have fixed colums A to D. The other columns contains the 8 different options, i would like to only show the columns for the option selected in the dropdown list. So if i select "food" from the dropdown in C2 i would like to hide columns N to T, and show columns E to M. Same for "drinks": hide E to M and T to Z, only show N to T and so on. If nothing is selected in C2 i would like for all columns exept A to D to be hidden. Any help with this would be much appreciated

[bmouse]

How many total columns are in use after A:D? From E to...?

[bmouse]

I made a simple macro which requires you to press a button to check for the value in C2. Depending on the value it shows/hides designated columns. If this kind of solution works for you and you are familiar with VBA, you can adjust the code to suit your needs.

[campina]

How many total columns are in use after A:D? From E to...?

fixed colums A:D, then colums E:BI

U sir are a lifesaver, thanks for your help. I have used your macro and adjusted the values for the columns to my needs and it works :-) As you may have noticed i'm new to VBA and macro's for that matter. Their is just one thing, i have selected shortkey for running the macro so i now select a option from the drop down press shift+ctrl+Q and then it hides/shows the correct columns. Is there a way to bypass using the shortkey so i only have to select a option from the dropdown and then the correct column shows without using the shortkeys? I have a feeling this is basic stuff but i'm just getting the hang of things so all help is very much welcome

[bmouse]

I am also a VBA noobie, but I gather your request would require the macro to be running constantly, without the need to run it, which, I believe, is not possible.

[campina]

Thanks for your reply, well i guess we can't have everything.
You deserve a trophy for helping me out on such short notice

[bmouse]

Glad to help, good luck