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

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

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

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