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 |
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 |
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 |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com