HOW TO RESTRICT DATA ENTRY FROM A CHOICE OF SEVERAL LIST?

[Guest]

In an excel worksheet I have 3 different list of products- CD, DVD and Game.
On a different worksheet i have two columns- Product type and Product
Description.
When I select a product type under on the Product type column I would like
the the appropriate list to appear on the Product descriptioin column.

 

[Norman Jones]

Hi Roomee,

Visit Debra Dalgleish's site and see her tutorial on creating Dependent
Lists:

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

See also xlDynamic's notes on Dependent Dropdowns at:

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