referencing mult drop down list
 

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??

referencing mult drop down list
 

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

regards
FSt1

"Eric" wrote:

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??

referencing mult drop down list
 

Don't worry I found another post and solve it^^ Thanks

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

"FSt1" wrote:

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

regards
FSt1

"Eric" wrote:

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??

referencing mult drop down list
 

hi
and for data validation, that was where i was going to point you.

regards
FSt1

"Eric" wrote:

Don't worry I found another post and solve it^^ Thanks

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

"FSt1" wrote:

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

regards
FSt1

"Eric" wrote:

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??