Hiding columns based on drop down list selection

**acadzow** · 12-25-2015, 08:52 AM

I have looked at many threads on this and cannot find a solution that will work for me.
I am trying to set up a sheduling system for my work. I have hundreds of columns that will have dates as the heading. There will be 6 columns per date to represent different shift timings.
I have a drop down box that you can pick the appropriate shift (2, 4, 6, 8, 12, 24).
When the shift is chosen, all columns that do not match the selection are hidden.

I have attached an example if anyone would be able to assist please.

**YasserKhalil** · 12-25-2015, 09:44 AM

Hello acadzow
Welcome to the forum
Right click on sheet tab and put this code

Please Login or Register  to view this content.

**davesexcel** · 12-25-2015, 09:45 AM

Unhide the columns first.

Please Login or Register  to view this content.

**acadzow** · 12-26-2015, 01:29 AM

Thanks, works perfectly, Much appreciated for the quick reply during Christmas.
Merry Christmas to all.

If I wanted to adjust which columns are shown, what would I change.
For example, if a 12 hour shift is chosen, all columns with a 0 and 12 would appear, hence start and finish times. If a 24 hour shift is chosen, all 3 choices would be visible.
I tried playing around with the code for this but seem to make everything worse.

Hiding columns based on drop down list selection

LinkBack

Thread Tools

Rate This Thread

Display

Hiding columns based on drop down list selection

Re: Hiding columns based on drop down list selection

Re: Hiding columns based on drop down list selection

Re: Hiding columns based on drop down list selection

Thread Information

Users Browsing this Thread

Similar Threads

Help hiding rows based on drop down selection

Hiding rows based on drop down selection of cell

[SOLVED] Hiding Columns based on the value of a drop down list

Hiding Columns based on Drop Down list selection

Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.

Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.

Hiding Rows based on Drop Down menu selection

Bookmarks

Bookmarks

Posting Permissions