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