ExcelBanter - Product List

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Product List (https://www.excelbanter.com/excel-worksheet-functions/177218-product-list.html)

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

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

Thank you, does the trick nicely.

Esra

On Tue, 19 Feb 2008 15:34:43 -0800, "RagDyer"
wrote:

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

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

Appreciate the feed-back.
--

Regards,

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

"Esra Dekan" wrote in message
...
Thank you, does the trick nicely.

Esra

On Tue, 19 Feb 2008 15:34:43 -0800, "RagDyer"
wrote:

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

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