two list box select item

[kalpeshpatel]

in sheet 1 i create 2 list box name is (1) date (2) docno


data is under


date docno


1-12-11 3465

1-12-11 3466

1-12-11 3467

1-12-11 3468

3-12-11 4051

3-12-11 4052

3-12-11 4053

10-12-11 6054

10-12-11 6055

10-12-11 6056


now my problem is when select date 1-12-11 from date list box then docno list shown only 3465,3466,3467,3468

date is 3-12-11 is select then docno list box shown only 4051,4052,4053


how it possible

 

[Luke M]

Check this out:

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


or,


If you want to get fancy, you could also setup a defined range somewhere that uses the formula described here:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/


to generate a list based upon the initial choice.