validation combobox

[Megatronixs]

Hi all,

I'm working on a file that has in it 2 columns that have validation list.
Now I need to select a cell in column D and choose from "rejected" or "partialy rejected" and from column E the reason
Is there a possible way that I select one cell in column D and a listbox opens and gives me choices when I select "rejected" or "partially rejected" like below example:


-------------------
rejected:

duplicate
unclear instructions
wrong client


-------------------
partially rejected:

possible duplicate
incorrect number
incorrect address



This means that when I click with the mouse on duplicate (below rejected), it will fill in column D "rejected" and in column E "duplicate"

I guess it can be done, but no idea how to do this in the Data>validation tab.
And better if it is done without vba.

Thanks in advance.

Greetings.

[Ace_XL]

You need dependent data validation

Look here
http://www.contextures.com/xlDataVal02.html

[akhileshgs]

I think that link is not working...

What you need is, name the first rejection reason list as 'Rejected' and 2nd as 'Partially_Rejected'

And in the validation, for E2, use the formula =Indirect(D1)

Remember, the space is not allowed in this type. So instead of 'Partially Rejected', you will have to use 'Partially_Rejected' or something like that everywhere

[Megatronixs]

Hi Ace,

I think I was not clear with my question. I wil try to formulate differently.
When I click on a cell with the validation and gives me 2 choices, but those 2 choices have below each one, a few more choices.
For example I need to fill in "rejected" in column D and having choosen a sub choice from it, this will be filled in column E.
The link you attachec, it only works like you choose fruit from the first and the second gives you choice of apple, orange and so on.
Then I just could combine all possible ones in the second list and choose from there. But I would like to have the possiblity to show a sublist below the main choice in column D.

Thanks and greetings.

[Megatronixs]

Hi akhileshgs,

Can you give an example. I tried to do it, but no clue how to get done.

greetings.

[akhileshgs]

Hi,
Sorry for the delay. I was busy in my own work..

here is the example...

There are 2 ways to get it done for 2 situations....

Hope the attached file will be enough.
If not, please dont hesitate to ask... I will be happy to help you

dynamic dropdown.xlsx