Combo Box Help

[GastonFranzini]

I need a combo box, to be filtered by another combo box,
In one I'll have surnames, and in the other names, E.G.

code Surname Name
1 Pan Peter
2 Doe John
3 Him Susan
4 Pan Paul

I need a combo box to display surnames, then the other I want to
display the names acording to the surname, and finally I want to store
the code in Cell B15

Thanks

 

[Debra Dalgleish]

If you can use data validation instead of combo boxes, you may be able
to adapt the technique show in the sample file here:

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

Under Data Validation, look for 'DV0037 - Dependent Lists Country City'

 

[GastonFranzini]

Thanks, but the list I have cant be ordered, and I need to show unique
values on the fist validation and on the second, I can´t order the
columns as in the example.
Thanks




Debra Dalgleish ha escrito: