Need advice on drop down menu

  • Thread starter Thread starter Rene
  • Start date Start date
R

Rene

I am trying to create a dropdown menu in some cells in a column of a
worksheet. What I envision is the end user will click the arrow for the drop
down menu and see a 3 digit code with a description following the 3 digits.
I have 2 columns that contain this info where the first column has the 3
digit code and the second column has the description. The user will select
the item that they want and then only the 3 digit code will be displayed.

I am using MS Excel 2000 and Windows 2000.
 
There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You should be able to adapt this
to your workbook.

On the following page:

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

Under the data validation heading, find 'Data Validation "Columns"' and
download the file named DataValNameID.xls
 
Back
Top