ExcelBanter - drop down help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - drop down help (https://www.excelbanter.com/excel-worksheet-functions/6579-drop-down-help.html)

I have a drop down menu where you can select location
e.g GLASGOW, EDINBURGH

when one of these is selected I want another drop down menu in the cell
below offering choices of subsurbs. eg if GLASGOW is selected in the cell
above I want choices such as GOVAN, PARTICK and if EDINBURGH is selected I
want choices like MORNINGSIDE, LEITH etc.

Please help me
--
Rob

Hi Rob

Check out Debra Dalgleish's site for information on how to do this is you're
using data validation to create the drop down boxes:

http://www.contextures.com/xlDataVal02.html

Cheers
JulieD

"rob102_uk" wrote in message
...
I have a drop down menu where you can select location
e.g GLASGOW, EDINBURGH

when one of these is selected I want another drop down menu in the cell
below offering choices of subsurbs. eg if GLASGOW is selected in the cell
above I want choices such as GOVAN, PARTICK and if EDINBURGH is selected I
want choices like MORNINGSIDE, LEITH etc.

Please help me
--
Rob