Lists and sub lists

[crafty]

I know how to create a drop down list but I don't know how to generate a
sub list for each of the selections on the main list. For instance
Makes of Cars (Autos) on the main list and Models for each Make on the
sub lists.
Can anyone help?
Crafty

 

[Anne Troy]

Try Debra's article:
http://www.contextures.com/xlDataVal02.html

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[crafty]

Many thanks to Bob Phillips and Anne Troy. Your help is greatly
appreciated. Ian Craft