create a drop down based on 2 previous inputs eg. country and are.

Z

Zippy

I wish to create a drop down in excel based on two previous conditions.
Condition 1 is country
Condition 2 is Area.

based on these responses I wish a third drop down to be created for crops eg
,rice ,wheat etc.

Can someone help me with this?
 
P

Paul B

Zippy, have a look here and see if this will help you
http://www.contextures.com/xlDataVal02.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
B

Bob Phillips

I have a sample workbook that just needs your data plugging in.

Mail me if you want a copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top