Drop down menu question

[gbarelz]

CLASSIFICATION	DROP-DOWN MENUS
C	drop-down menu C
B	drop-down menu B
A	drop-down menu A
C	drop-down menu C
B	drop-down menu B

Hi,

I am trying to make different dropdown menus depending on the classification cell that is right next to it. So, for instance, if I have classification "D", I want to have a drop down menu for D. I was thinking of making the different lists on a different spreadsheet for each classification... but then once I do that, how do I set it so that whenever there is C in cell A2, for instance, I want to have ONLY the drop down list for A... Does anyone have any idea how to do that?

[navic]

Does anyone have any idea how to do that?

try see Dynamic Dependent Excel Drop Downs
or Create Dependent Drop Down Lists