Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create synchronised lists in Excel?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create synchronised lists in Excel?
http://www.contextures.on.ca/xlDataVal02.html
Gord Dibben MS Excel MVP On Mon, 22 Mar 2010 05:47:01 -0700, 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create synchronised lists in Excel?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel -- Data Validation -- Create Dependent Lists | Excel Worksheet Functions | |||
Keeping rows synchronised | Excel Worksheet Functions | |||
Create Outlook Distribution lists in Excel VBA | Excel Discussion (Misc queries) | |||
Create Outlook Distribution lists in Excel VBA | Excel Programming | |||
Dependent Validation in SharePoint-synchronised list | Excel Discussion (Misc queries) |