Dependant Dropdowns - Addition of third list
 

I'm in need of some help regarding Dependant Dropdowns. I've read the
tutotial at http://www.contextures.com and http://www.xldynamic.com which
both show examples for just 2 dropdowns with the second dropdown dependant on
the first. I want to add a third dropdown list which is dependant on the
information selected in both the first and second dropdown lists.

The information on www.xldynamic.com produced by Bob Phillips does make
reference to a third (and forth) list/dropdown but in the actual example
there are only two. I've been looking at the Data Validation version as it
fits in with other validation that I am using in the same sheet.

I'm trying to acheive the same function that is demonstrated with Continent,
Country and City on www.xldynamic.com under Dynamic Dependant Dropdowns.

Your help would be greatly appreciated.

Dependant Dropdowns - Addition of third list
 

Hi!

What exactly are you having problems with?

You just use the same technique for a third dd as you did for the second dd.

Biff

"Puzzled Percy" wrote in message
...
I'm in need of some help regarding Dependant Dropdowns. I've read the
tutotial at http://www.contextures.com and http://www.xldynamic.com which
both show examples for just 2 dropdowns with the second dropdown dependant
on
the first. I want to add a third dropdown list which is dependant on the
information selected in both the first and second dropdown lists.

The information on www.xldynamic.com produced by Bob Phillips does make
reference to a third (and forth) list/dropdown but in the actual example
there are only two. I've been looking at the Data Validation version as
it
fits in with other validation that I am using in the same sheet.

I'm trying to acheive the same function that is demonstrated with
Continent,
Country and City on www.xldynamic.com under Dynamic Dependant Dropdowns.

Your help would be greatly appreciated.

Dependant Dropdowns - Addition of third list
 

I'm not sure how I'm meant change the data layout to add the information for
the third list. The way that the first two lists are laid out is quite
logical but how do I add my data for the third list? (probably a stupid
question). Sorry, I'm new to working out this kind of stuff.

Puzzled Percy

"Biff" wrote:

Hi!

What exactly are you having problems with?

You just use the same technique for a third dd as you did for the second dd.

Biff

"Puzzled Percy" wrote in message
...
I'm in need of some help regarding Dependant Dropdowns. I've read the
tutotial at http://www.contextures.com and http://www.xldynamic.com which
both show examples for just 2 dropdowns with the second dropdown dependant
on
the first. I want to add a third dropdown list which is dependant on the
information selected in both the first and second dropdown lists.

The information on www.xldynamic.com produced by Bob Phillips does make
reference to a third (and forth) list/dropdown but in the actual example
there are only two. I've been looking at the Data Validation version as
it
fits in with other validation that I am using in the same sheet.

I'm trying to acheive the same function that is demonstrated with
Continent,
Country and City on www.xldynamic.com under Dynamic Dependant Dropdowns.

Your help would be greatly appreciated.