I am trying to write a purchase order for my company in MS-Excel 2002.
I am currently using a validation / dropdown list to pick th
description of the product I want from a list of 100 choices.

I would like to break the list of 100 items into five categories of 2
items each to make selection easier.

One column would list five categories in a drop down menu.

The next column would allow me to choose from the twenty products unde
that category.

I am not sure of the formula or code to accomplish this task.

Please advise.

Ed Suly

--
Message posted from http://www.ExcelForum.com

Hi Ed
have a look at the following site for dependent data validation
http://www.contextures.com/xlDataVal02.html

HTH
Frank


I am trying to write a purchase order for my company in MS-Excel
2002.
I am currently using a validation / dropdown list to pick the
description of the product I want from a list of 100 choices.

I would like to break the list of 100 items into five categories of
20
items each to make selection easier.

One column would list five categories in a drop down menu.

The next column would allow me to choose from the twenty products
under that category.

I am not sure of the formula or code to accomplish this task.

Please advise.

Ed Sulya


---
Message posted from http://www.ExcelForum.com/

See Debra Dalgleish's site on this topic

Dependent lists - data validation
http://www.contextures.com/xlDataVal02.html

Related topics:
Datavalidation - top
http://www.contextures.com/xlDataVal01.html

--
Regards,
Tom Ogilvy


"edsulya " wrote in message
...
I am trying to write a purchase order for my company in MS-Excel 2002.
I am currently using a validation / dropdown list to pick the
description of the product I want from a list of 100 choices.

I would like to break the list of 100 items into five categories of 20
items each to make selection easier.

One column would list five categories in a drop down menu.

The next column would allow me to choose from the twenty products under
that category.

I am not sure of the formula or code to accomplish this task.

Please advise.

Ed Sulya


---
Message posted from http://www.ExcelForum.com/

Edsulya,

Suppose your dropdownboxes are in A1(1 to 5) and in A2 (20 values)

Name the ranges of 20 values : I assume in this example List1, List2,
....,List5

In A1 Data/Validation / List / 1,2,3,4,5

In A2 Data / Validation/List/ =Choose(A1,List1,List2,List3,List4,List5)

NB When a choice is made in cell A2 and thereafter cell A1 is changed, there
will be no errrormessage that a wrong list is used in cell A2.
(This is always the case with DATA / Validation)


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"edsulya " wrote in message
...
I am trying to write a purchase order for my company in MS-Excel 2002.
I am currently using a validation / dropdown list to pick the
description of the product I want from a list of 100 choices.

I would like to break the list of 100 items into five categories of 20
items each to make selection easier.

One column would list five categories in a drop down menu.

The next column would allow me to choose from the twenty products under
that category.

I am not sure of the formula or code to accomplish this task.

Please advise.

Ed Sulya


---
Message posted from http://www.ExcelForum.com/

Look at this example from Debra
http://www.contextures.com/xlDataVal02.html

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"edsulya " wrote in message ...
I am trying to write a purchase order for my company in MS-Excel 2002.
I am currently using a validation / dropdown list to pick the
description of the product I want from a list of 100 choices.

I would like to break the list of 100 items into five categories of 20
items each to make selection easier.

One column would list five categories in a drop down menu.

The next column would allow me to choose from the twenty products under
that category.

I am not sure of the formula or code to accomplish this task.

Please advise.

Ed Sulya


---
Message posted from http://www.ExcelForum.com/

I've never tried what you're describing. But there's a lot of Data
Validation information on Debra Dalgleish's web site -
http://www.contextures.com/ . You might find some help there.

Sorry I couldn't do more for you.
Ed

"edsulya " wrote in message
...
I am trying to write a purchase order for my company in MS-Excel 2002.
I am currently using a validation / dropdown list to pick the
description of the product I want from a list of 100 choices.

I would like to break the list of 100 items into five categories of 20
items each to make selection easier.

One column would list five categories in a drop down menu.

The next column would allow me to choose from the twenty products under
that category.

I am not sure of the formula or code to accomplish this task.

Please advise.

Ed Sulya


---
Message posted from http://www.ExcelForum.com/