2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to Make Column B Selections dependent on Column A Selection

Apologies for the confusing title, I'm too naive to know exactly how to describe this. Essentially what I need to do is make a drop-down list for two different columns where the second depends on the first. Say I have a table like this:

Drink Brand/Type
Soda Coke, Diet Coke, Sprite, Pepsi, Diet Pepsi, Mountain Dew
Water Dasani, Fuji
Wine Red, White
Sparkling Water Waterloo, Sanpellegrino, Spindrift

I want the first column's choice to affect what you can choose in the second column. I currently have Data Validation lists for both columns separately so even when I choose 'Soda' in Column A, then Column B has all of the Brand/Types listed including things like 'Dasani' and 'White' or 'Red' wine. When I select Soda in Column A, I only want the list of sodas to be available in Column B.

Hope this makes sense. I imagine this should be easy enough to do, but I can't seem to figure it out because I'm an idiot lol.

submitted by /u/toomuchsoysauce
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article