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

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


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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