Creating a Data Validation List based on a Value in another cell

L

LondonLion

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
 
F

FC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Validation of cell based on Drop down list 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Limit drop down items based on another cell 3
Data Validation - Complex Q 2
Return a list based on +/- of a cell value 0
Return a list based on a +/- of a cell value 14
Creating a Chart on form from selected data in query. 0

Top