How do I create synchronised lists in Excel?

K

Kimtab

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
Read Dropdown list from Excel column 51
Define the Range of a drop-down list 5
Inserting rows if a particular item is chosen from a list 1
Validation list 2
Data Validation - List 2
synchronising data in 2 excel files 5
Require answer dependant upon earlier cell information 1

Top