Take a look he

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

HTH

"shezzer_1972" wrote:

I need to create a spreadsheet whereby the user can select a drop down menu
opiton. This is the difficulty for me, my first drop down will select an area
i.e.
Uk
USA
France

But the second drop down will offer places specific to the location selected
in the first box. So if the user selected UK in the first box then would
then be offered a choice of say
London
Edinburgh
Cardiff

in the second. For those selecting USA they would be offered cities in the
USA.

Pls help I'm really struggling to know what format to enable this and need
it for work for tomorrow.

thank you

s