Excel Validation / Dropdown list Problem

E

edsulya

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
 
A

A.W.J. Ales

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 *
 
E

Ed

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
 
Top