Is it possible in Excel to have 2 drop down boxex where the information in the second one depends on what is selected in the first one?
For example I have a big list in excel of names. Each name can be a part of Group A or Group B (this is specified in a column next to the name). I was wondering if you can have a drop down box where you would select either A or B and then the next drop down box would show only the names corresponding to that group. The list is arranged in order of name, not group.
Thanks for any help. Much appriciated. Ant
For example I have a big list in excel of names. Each name can be a part of Group A or Group B (this is specified in a column next to the name). I was wondering if you can have a drop down box where you would select either A or B and then the next drop down box would show only the names corresponding to that group. The list is arranged in order of name, not group.
Thanks for any help. Much appriciated. Ant