Conditional drop-down lists

[Paul Green]

HI there.

I'm trying to recreate a web form in Excel. The form populates a drop-down
list based on the selection in the previous drop-down list (1st list has
about 10 items, and each related list about the same again).

Any thoughts or ideas how i might be able to acheive this?

Thanks
paul.

 

[Paul B]

Paul, see if this will help,

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 2002 & 2003

 

[Paul Green]

Paul

Thanks so much - absolutely what I needed!

p.