Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding data validation
I need to create a spreadsheet whereby the user can select a drop down menu
opiton. This is the difficulty for me, my first drop down will select an area i.e. Uk USA France But the second drop down will offer places specific to the location selected in the first box. So if the user selected UK in the first box then would then be offered a choice of say London Edinburgh Cardiff in the second. For those selecting USA they would be offered cities in the USA. Pls help I'm really struggling to know what format to enable this and need it for work for tomorrow. thank you s |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding data validation
Take a look he
http://www.contextures.com/xlDataVal02.html HTH "shezzer_1972" wrote: I need to create a spreadsheet whereby the user can select a drop down menu opiton. This is the difficulty for me, my first drop down will select an area i.e. Uk USA France But the second drop down will offer places specific to the location selected in the first box. So if the user selected UK in the first box then would then be offered a choice of say London Edinburgh Cardiff in the second. For those selecting USA they would be offered cities in the USA. Pls help I'm really struggling to know what format to enable this and need it for work for tomorrow. thank you s |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding data validation
Hi Toppers
thanks for your reply,I'm not very good at excel so apologies for perhaps the simpleness of this question! My first column is also a pick list so I can't see how this works. In the example on this page the categories are already established in the list?? Am I mising something? thank you g "shezzer_1972" wrote: I need to create a spreadsheet whereby the user can select a drop down menu opiton. This is the difficulty for me, my first drop down will select an area i.e. Uk USA France But the second drop down will offer places specific to the location selected in the first box. So if the user selected UK in the first box then would then be offered a choice of say London Edinburgh Cardiff in the second. For those selecting USA they would be offered cities in the USA. Pls help I'm really struggling to know what format to enable this and need it for work for tomorrow. thank you s |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding data validation
If you read down to the section titled "Apply the Data Validation",
you'll see that both columns have dropdown lists. shezzer_1972 wrote: Hi Toppers thanks for your reply,I'm not very good at excel so apologies for perhaps the simpleness of this question! My first column is also a pick list so I can't see how this works. In the example on this page the categories are already established in the list?? Am I mising something? thank you g "shezzer_1972" wrote: I need to create a spreadsheet whereby the user can select a drop down menu opiton. This is the difficulty for me, my first drop down will select an area i.e. Uk USA France But the second drop down will offer places specific to the location selected in the first box. So if the user selected UK in the first box then would then be offered a choice of say London Edinburgh Cardiff in the second. For those selecting USA they would be offered cities in the USA. Pls help I'm really struggling to know what format to enable this and need it for work for tomorrow. thank you s -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Validation List -adding data and using it later | Excel Discussion (Misc queries) | |||
Adding a blank in Data Validation List? | Excel Discussion (Misc queries) | |||
Adding an extra validation to this formula. | Excel Discussion (Misc queries) |