| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a Data Validation List based on a Value in another cell
Hi, I wonder if anybody can help
In cell A1 there are multiple options eg London, Birmingham, Manchester, I twould like a data validation list to appear in cell B! based on the value in cell B1 so if it is London I have a drop down list of Waterloo, Victoria, Kings Cross etc, but if it is Birmingham then I have a drop down list of New Street, International Airport etc Hope this make sense. Thanks in advance for any help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a Data Validation List based on a Value in another cell
Hi
Take a look here http://www.contextures.com/xlDataVal13.html -- Regards Roger Govier "LondonLion" wrote in message ... Hi, I wonder if anybody can help In cell A1 there are multiple options eg London, Birmingham, Manchester, I twould like a data validation list to appear in cell B! based on the value in cell B1 so if it is London I have a drop down list of Waterloo, Victoria, Kings Cross etc, but if it is Birmingham then I have a drop down list of New Street, International Airport etc Hope this make sense. Thanks in advance for any help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a Data Validation List based on a Value in another cell
You'll need DATA VALIDATION for one dropdown list and INDIRECT DATA
VALIDATION for the other one ( 2 dropdown lists ). If you need directions write me back, I'm coming back in 1 hour. "LondonLion" wrote: Hi, I wonder if anybody can help In cell A1 there are multiple options eg London, Birmingham, Manchester, I twould like a data validation list to appear in cell B! based on the value in cell B1 so if it is London I have a drop down list of Waterloo, Victoria, Kings Cross etc, but if it is Birmingham then I have a drop down list of New Street, International Airport etc Hope this make sense. Thanks in advance for any help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automating Address Information based on selecting data via a validation list | Excel Worksheet Functions | |||
| Creating a List based on your choice from Another List | Excel Discussion (Misc queries) | |||
| Creating a list (data validation) fromt wo different source ranges | Excel Discussion (Misc queries) | |||
| How do you create a list & data validation in same cell? | Excel Worksheet Functions | |||
| data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
Linear Mode
