Multi-level dependent data validation

A

aussiemate65

Hi,

I need to set up an excel sheet with dependent data validation that is
multiple levels deep.

ie. Select value from dropdown list in Col A returns dependant list in Col
B, select value from the list in Col B returns list in Col C etc.

Is this possible?

Also, is it possible to set multiple values to return the same list? ie in
the drop down you have 4 items. Each returns a dependent list but items 1 and
3 both return the same dependent list. Just saves me making many copies of
the same list with different names which isn't a huge issue.

Really appreciate any help you can provide.
 
R

Roger Govier

Hi
Take a look at the tutorial I created at Debra Dalgleish's site
http://www.contextures.com/xlDataVal15.html

I have another version which has not been uploaded yet, which will clear all
entries to the right, if a value from the dropdown list changes.
Post back with your email address if you need this version

--
-------
Regards
Roger Govier

aussiemate65 said:
Hi,

I need to set up an excel sheet with dependent data validation that is
multiple levels deep.

ie. Select value from dropdown list in Col A returns dependant list in Col
B, select value from the list in Col B returns list in Col C etc.

Is this possible?

Also, is it possible to set multiple values to return the same list? ie in
the drop down you have 4 items. Each returns a dependent list but items 1
and
3 both return the same dependent list. Just saves me making many copies of
the same list with different names which isn't a huge issue.

Really appreciate any help you can provide.

__________ Information from ESET Smart Security, version of virus
signature database 4893 (20100224) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4893 (20100224) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

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

Top