I want to create synchronised validated lists in Excel so that, when I choose
one item from the first list, I can only choose from a set items in the
second list. If I choose a different item in the first list, I will only be
able to choose from a different set of items in the second list. Is there a
way to do this? I am using Excel 2007, with Windows XP.

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


Gord Dibben MS Excel MVP


On Mon, 22 Mar 2010 05:47:01 -0700, Kimtab
<(E-Mail Removed)> wrote:

>I want to create synchronised validated lists in Excel so that, when I choose
>one item from the first list, I can only choose from a set items in the
>second list. If I choose a different item in the first list, I will only be
>able to choose from a different set of items in the second list. Is there a
>way to do this? I am using Excel 2007, with Windows XP.

Take a look at this:
http://www.contextures.com/xlDataval02.html

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Kimtab" wrote:

> I want to create synchronised validated lists in Excel so that, when I choose
> one item from the first list, I can only choose from a set items in the
> second list. If I choose a different item in the first list, I will only be
> able to choose from a different set of items in the second list. Is there a
> way to do this? I am using Excel 2007, with Windows XP.