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