Hiding cells from a drop down list

[Aris]

I have seen a few threads here about this, but not for how I need it to work.

I will have a drop down list with 8 options, (Days of the week Wed to Wed, hence the 8 days lol)
There will now be 8 columns, one for each day.

I want to be able to select the day from the list, and then have it hide all the columns except for the day selected.
When a different day is picked, un hide that one and hide the rest.

I will attach a book in the reply...

[Aris]

Book1 Testing.xlsx

Thanks!

[mikeTRON]

This would be an easy VBA solution if that is what you are looking for.

[Aris]

This would be an easy VBA solution if that is what you are looking for.

Yep. I looked online, and all I found was a drop down with 2 options, yes or no. I need my choices to match the column headers as it will change week to week.

[gak67]

To hide and unhide columns automatically you will need to use VBA as mikeTRON has suggested. You could use conditional formatting to highlight the current selection though.

[Aris]

To hide and unhide columns automatically you will need to use VBA as mikeTRON has suggested. You could use conditional formatting to highlight the current selection though.

That's what I need, I just don't have the VBA skills. I also noticed, I posted this in the wrong forum, crap. Sorry! Can a mod move this to the VBA section? Thanks!

[kvsrinivasamurthy]

Pl see the attached file. worksheet_Change event is used.

[Aris]

Pl see the attached file. worksheet_Change event is used.

Works Great!!! If I wanted to add one item, like All to show all columns, what code would I add? I want to learn all this, where is a good resource to read on coding?

[Aris]

To copy this to my workbook, I just paste in the code and change the cell references correct?

[Fotis1991]

I also noticed, I posted this in the wrong forum, crap. Sorry! Can a mod move this to the VBA section? Thanks!

Done!

........................

[kvsrinivasamurthy]

Yes is the answer to your doubt.
Pl see attached file.

[Aris]

You guys are awesome!! I'll mark this as solved! Thanks again!

[Aris]

How do I mark it solved?

[Fotis1991]

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Aris]

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Done. Thanks!