Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In cell drop down
Hello
I was wondering if their is any way to have a drop down box that will hold both an account number and account name but only input the account number into the box. Or if their is another or better way to do this. Thanks-Mark |
#2
|
|||
|
|||
Hi
one way: See: http://www.contextures.com/excelfiles.html and search for Data Validation "Columns" -- Regards Frank Kabel Frankfurt, Germany "Markitos" schrieb im Newsbeitrag ... Hello I was wondering if their is any way to have a drop down box that will hold both an account number and account name but only input the account number into the box. Or if their is another or better way to do this. Thanks-Mark |
#3
|
|||
|
|||
Thanks Frank for that great site. I downloaded the sample file. But I still
didnt get it, Im not good at Codes (macros) BUT I went on the sheet and selected an item ID AND name and I counldnt get it to change over into just one of them. Thanks- Mark "Frank Kabel" wrote: Hi one way: See: http://www.contextures.com/excelfiles.html and search for Data Validation "Columns" -- Regards Frank Kabel Frankfurt, Germany "Markitos" schrieb im Newsbeitrag ... Hello I was wondering if their is any way to have a drop down box that will hold both an account number and account name but only input the account number into the box. Or if their is another or better way to do this. Thanks-Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a drop down in XL cell to select date | Excel Worksheet Functions | |||
Removing a drop down list from a cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Place a set value in a cell from a drop down list name reference | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |