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