Change the value in the dropw down list on the change in the value of another dropdown list

i have an excel file which has two drop down list. the first drop down list contains values "Total, Graduate, Non Graduate".
if the value is Total then the second drop down list should have value of "Total"
if the value is Graduate then the second drop down list should have value of "Total", "B.Sc","B.Com","B.B.A"
if the value is Non Graduate then the second drop down list should have value of "Total", "Diploma", "Intermediate"

for displaying the proper values in the second drop down, I have created a name manager and assigned it to the second dropdown list
=IF(Suport!$K$2=1,IN!$F$19,IF(Suport!$K$2=2,IN!$F$20:$F$23,IF(Suport!$K$2=3,IN!$F$24:$F$26)))

when I have "Total" selected in the first drop down and "Total" selected in second drop down, then it works fine but when I try to select "Graduate" and then "B.B.A." and then change the value of first drop down to "Total" it is not able to change the value of the second drop down in the cell link on the vasis of the modified input range.

LVL 5
logideepakAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
The value of a cell won't change unless you specifically change it manually or with VBA. Only the list in the dropdown list will change.

Kevin
0
 
jppintoCommented:
Please check if my article about "Cascading Validation Lists" is what you're looking for:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_4454-Cascading-Validation-Lists.html

jppinto
0
 
zorvek (Kevin Jones)ConsultantCommented:
The article by jppinto does not answer the question. The question is:

"...when I try to select "Graduate" and then "B.B.A." and then change the value of first drop down to "Total" it is not able to change the value of the second drop down in the cell link on the vasis of the modified input range."

My post addresses the problem by stating that:

"The value of a cell won't change unless you specifically change it manually or with VBA. Only the list in the dropdown list will change."

It is not a complete solution but it addresses the problem - that being how to adjust a downstream cell value when an upstream cell value changes which affects the valid values in the downstream cell.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
0
 
ModalotEE ModeratorCommented:
Implementing recommendation from the participating Expert(s).

Modalot
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.