Dependent/Dynamic Drop Down Lists

Friends,

I have this list of groceries.

Fruits, Vegetables, Beverages, and etc.

Fruits' list contains its related items, Vegetables its items, and so on.

So far, it's done as such.

But here is the thing, if I select the first list to be "None", then, all other after lists should automatically become to "None" status.

Furthermore, if I select one item in Fruits but "None" in the after list, then the other after remaining lists should become to "None" status, not touching the status of the list before.

These lists shouldn't be dependent other than when I select "None" then the lists that are after the list should also become to "None" status.

It's not complicated, it's just I am not good at explaining stuff.

I really hope everyone understand where I am coming from.

Please see attached.

you can use an if statement in the data validation to test if the previous dependant is none and then only show "none" as list option

I tried but I couldn't do it. Could you please use the file to show? Please.

The column shouldn't extend.

Fruits, Vegetables, Beverages, and etc. should stay in its cells with its lists intact.

It's confusing because I can select only one item from, for example, in Fruits. If I select Apples in Fruits, then I can continue to select Tomatoes from Vegetables, and so on.

However, once I select None in Fruits, then, Vegetables, Beverages, and etc., should all become to None.

Moreover, if I select Apples in Fruits, then None in Vegetables, then, other remaining should become to None.

It's like unlocking lists when moving forward but once None is selected then going forward comes to a stop.

Am I making sense?

And I really like the idea how the next cell becomes to a stop of None. Which is perfect! Thanks for that!
But again, the list or cells shouldn't extend.

Yes, almost perfect.

When I select None, the next cell has to be changed manually to None.

Can't it be done automatically?

I mean, as soon as I select None, the others should become None too without having to select it.

Please.

I also very much like this idea too.

I mean, it's another logic way to look at it.

Anyways, and however, I have got what I needed which is just great.

So, thank you again, as always, you are the man, man! :D

Originally Posted by JohnTopley

I did a VBA version but as you appear to be OK with current solution(s) I'll let that lie.

Thank you for the feedback and rep.

No, no, no, don't let your precious work to lie! I appreciate every single thing that you do in Excel!

Please do share it with me if you didn't let it go to waste!

Originally Posted by JohnTopley

Please Login or Register  to view this content.

Select category in A2

Select blank cell in B to get list

Enter data
move to next blank cell

Each entry is "hard-coded" so when you move to the next cell the DV list is removed from the previous entry.

If you want to change an earlier entry, delete it from B then select Category in A2 to get a new DV list.

Whether you choose you this ....!

Wow, this is great Thank you, really! Perfect job!