i need to limit the available selections in a drop down list based on data in
adjacent cells.
ex: if LEFT(A1,1)="D" and LEFT(B2,1)="D" then the list contains options a, b
& c.
if LEFT(A1,1)="D" and LEFT(B2,1)="T" then list should have options d, e & f.
i am using a data validation drop down list because i am not familiar with
visual basic or in using activeX control objects. i think i may need to use a
list box.
please help and thanks in advance.