Variable validation lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hughcs - 28 Sep 2005 21:12 GMT

I would like to be able to create a pull-down list in Column A that
would determine the pull-down list made available in column B. (For
example, in column A there might be a pull-down list that included
fruit, vegetable, and meat, and depending on which you chose, column B
would provide a pull-down list of fruits, vegetables or meats.)

Signature

hughcs

Reply to this Message

Gord Dibben - 28 Sep 2005 22:42 GMT

Debra Dalgleish has instructions for creating dependent lists at her site.

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben Excel MVP

>I would like to be able to create a pull-down list in Column A that
>would determine the pull-down list made available in column B. (For
>example, in column A there might be a pull-down list that included
>fruit, vegetable, and meat, and depending on which you chose, column B
>would provide a pull-down list of fruits, vegetables or meats.)

Reply to this Message