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.

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" wrote in message
...
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.