Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation (Multiple Choice)
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation (Multiple Choice)
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation (Multiple Choice)
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation (Multiple Choice)
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation (Multiple Choice)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Automatic Data Validation drop down creation | Excel Discussion (Misc queries) | |||
Data validation for Multiple columns | Excel Discussion (Misc queries) | |||
Data Validation | Excel Discussion (Misc queries) |