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

[Roomee]

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


---
Regards,
Norman



"Roomee" <[email protected]> wrote in message
news:[email protected]...
> 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.