I have a problem that I hope someone can resolve for me. I suspect that

the solution may require VBA however my skills are quite limited.

Here is what I am trying to do:


I have created a spreadsheet with a list that a user will populate.
Within the list are a number of fields, most with drop down lists
created using data validation. As the user completes the fields running

from left to right the data validation fillters the choices the user
has to selct from. e.g the first selection is Gender: The user selects
Female, the next selection is Category, data validation only allows the

user to select categories that apply to females e.g. Skirts. I am using

a combination of ranges and indirect formulars to acheive this.


This approach works fine for most fields however:


As the user selects more and more fields they finally arrive at "style
level". They select the style from a list of around 1000 styles. The
next selection they need to make is colour. What I am trying to do is
get the data validation list to only show the colour options that are
relevant for that style; this may range from 1 to 10 different colours.

I obviously can't addopt the same approach of named ranges as I would
have to create a named range for each style that contained the colour
options in it.


Any help would be welcome. Sorry if my explanation is a bit wordy.


John

See http://www.contextures.com/xlDataVal02.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John" wrote in message
ups.com...
I have a problem that I hope someone can resolve for me. I suspect that

the solution may require VBA however my skills are quite limited.

Here is what I am trying to do:


I have created a spreadsheet with a list that a user will populate.
Within the list are a number of fields, most with drop down lists
created using data validation. As the user completes the fields running

from left to right the data validation fillters the choices the user
has to selct from. e.g the first selection is Gender: The user selects
Female, the next selection is Category, data validation only allows the

user to select categories that apply to females e.g. Skirts. I am using

a combination of ranges and indirect formulars to acheive this.


This approach works fine for most fields however:


As the user selects more and more fields they finally arrive at "style
level". They select the style from a list of around 1000 styles. The
next selection they need to make is colour. What I am trying to do is
get the data validation list to only show the colour options that are
relevant for that style; this may range from 1 to 10 different colours.

I obviously can't addopt the same approach of named ranges as I would
have to create a named range for each style that contained the colour
options in it.


Any help would be welcome. Sorry if my explanation is a bit wordy.


John