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 Im 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

Take a look he

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

In article ,
John Jost 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 Im 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

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
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

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

"JE McGimpsey" wrote:

Take a look he

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

In article ,
John Jost 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

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
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 Im 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