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

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

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