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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top