Variable validation lists

[hughcs]

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.)

[Gord Dibben]

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

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


Gord Dibben Excel MVP

On Wed, 28 Sep 2005 15:12:48 -0500, hughcs
<[email protected]> wrote:

>
>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.)