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.

Please refer the below link by Debra Dalgleish

on the subject
"Excel -- Data Validation -- Dependent Dropdowns from a Sorted List "
http://www.contextures.com/xlDataVal13.html

"Excel Data Validation -- Create Dependent Lists"
http://www.contextures.com/xlDataVal02.html

--
Jacob


"aussiemate65" wrote:

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.

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" wrote in message
...
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

Excel 2007 Tables
Multiple dependent drop-downs.
With macro.
http://c0444202.cdn.cloudfiles.racks.../12_14_09.xlsm