referencing mult drop down list

E

Eric

For e.g: a set of data:

UB UC
1 23
2 444
3 1
4


I have created a drop down list allowing me to select heading UB, UC.
I need another drop list that will allow me the select the values under
those headings, and the values on this list should depend on which heading i
select...i.e. If i select UB in the first drop list, the values under UB
should appear on the second drop list.

Anyone knows how to make that happen??
 
F

FSt1

hi
how did you create the dropdown lists?
with a sheet combo box or data validation?

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
list or combo box 0
Limit drop down items based on another cell 3
drop down list 1
Formatted cell column in drop down list 1

Top