I learnt how to do drop down menus for cells, but I would like the drop down
menu to display one word but enter in a different character in the cell when
it is selected.
I learnt how to do drop down menus for cells, but I would like the drop down
menu to display one word but enter in a different character in the cell when
it is selected.
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
Please help wrote:
> I learnt how to do drop down menus for cells, but I would like the drop down
> menu to display one word but enter in a different character in the cell when
> it is selected.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks