conditional drop down menu

[Guest]

Hi,

I am trying to link the answer that is given in one drop-down menu so that
the available answers in the second drop-down menu are limited. (Excel 2003)

Right now I have two columns with drop down menus, one call broad reason and
the other called narrow reason. Both are independant right now. I want it so
that if certain broad reasons are selected from the first column, that only
the narrow reasons which are applicable to that broad reason are chooseable.

Example: if broad reason selected is: Failure to Pay Then the choices
under narrow reason drop down should only be Rent, Fees, or Goods delivered.
But if broad reason selected is something else I want there to be different,
appropriate choices under the narrow reason drop down.

Thanks!

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal02.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)