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

--
---
HTH

Bob

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



"Anamillia" wrote in message
...
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!