Data Validation (Multiple Choice)

[John Jost]

I am working on a spreadsheet that will contain data that will be loaded into
a database. As we will need to validate the information being entered, I am
planning on using the �Data, Validation� fields to load valid values.
However I�m stumped. Based on the country selected from my country list, I
want to display one of two state lists (valid values). If USA is selected as
country I want to display the US state list. If Canada is selected, I want
to display the Canadian Province list. If any other country is selected I
want to allow the user to type any value.

Any suggestions

[JE McGimpsey]

Take a look here:

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

In article <[email protected]>,
John Jost <[email protected]> wrote:

> I am working on a spreadsheet that will contain data that will be loaded into
> a database. As we will need to validate the information being entered, I am
> planning on using the “Data, Validation” fields to load valid values.
> However I’m stumped. Based on the country selected from my country list, I
> want to display one of two state lists (valid values). If USA is selected as
> country I want to display the US state list. If Canada is selected, I want
> to display the Canadian Province list. If any other country is selected I
> want to allow the user to type any value.
>
> Any suggestions

[Gord Dibben]

John

Sounds like you want dependent lists.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben Excel MVP

On Mon, 12 Dec 2005 06:56:02 -0800, John Jost
<[email protected]> wrote:

>I am working on a spreadsheet that will contain data that will be loaded into
>a database. As we will need to validate the information being entered, I am
>planning on using the �Data, Validation� fields to load valid values.
>However I�m stumped. Based on the country selected from my country list, I
>want to display one of two state lists (valid values). If USA is selected as
>country I want to display the US state list. If Canada is selected, I want
>to display the Canadian Province list. If any other country is selected I
>want to allow the user to type any value.
>
>Any suggestions

[John Jost]

Thanks VERY much, this looks exactly like what I need. You help is greatly
appreciated.

"JE McGimpsey" wrote:

> Take a look here:
>
> http://www.contextures.com/xlDataVal02.html
>
> In article <[email protected]>,
> John Jost <[email protected]> wrote:
>
> > I am working on a spreadsheet that will contain data that will be loaded into
> > a database. As we will need to validate the information being entered, I am
> > planning on using the “Data, Validation” fields to load valid values.
> > However I’m stumped. Based on the country selected from my country list, I
> > want to display one of two state lists (valid values). If USA is selected as
> > country I want to display the US state list. If Canada is selected, I want
> > to display the Canadian Province list. If any other country is selected I
> > want to allow the user to type any value.
> >
> > Any suggestions
>

[John Jost]

Thanks VERY much, this looks exactly like what I need. You help is greatly
appreciated.

"Gord Dibben" wrote:

> John
>
> Sounds like you want dependent lists.
>
> See Debra Dalgleish's site for instructions.
>
> http://www.contextures.on.ca/xlDataVal02.html
>
>
> Gord Dibben Excel MVP
>
> On Mon, 12 Dec 2005 06:56:02 -0800, John Jost
> <[email protected]> wrote:
>
> >I am working on a spreadsheet that will contain data that will be loaded into
> >a database. As we will need to validate the information being entered, I am
> >planning on using the “Data, Validation” fields to load valid values.
> >However I’m stumped. Based on the country selected from my country list, I
> >want to display one of two state lists (valid values). If USA is selected as
> >country I want to display the US state list. If Canada is selected, I want
> >to display the Canadian Province list. If any other country is selected I
> >want to allow the user to type any value.
> >
> >Any suggestions
>