Product List

[Esra Dekan]

OK, here is a curly one. Least I think but most of them are to me.

I want to make a product list. I am using Data Validation to select
the product in the first column, and trhen I wish the second column,
after the first one is selected,. gives a list of items.

EG

If A1 is selected as Motherboards, then I wish the B1 to give types of
motheboards (taken from a separate list elsewhere). If A1 is selected
Hard Drives, I wish B1 to give types of Hard drives etc.

Is there an easy way of doing this?

I am using Excel 2007.


TIA
Esra

 

[RagDyer]

Debra Dalgleish has some web pages on this, called "dependent Lists":

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

 

[Esra Dekan]

Thank you, does the trick nicely.

Esra

 

[RagDyeR]

Appreciate the feed-back.