 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008drop down list
Hello Through Data > Validation, I've created a drop down list for a column to enable the user, when going into the cell , to choose what is listed. They are 3 letter codes. ie. RCC | Royal Caribean Cruise line RML | Royal Mail PCC | Portsmouth City Council When clicking on the down arrow in the cell and seeing the list of codes, is there a way of also being able to see what the code relates to which i've put in a colum along side the colum containing the list of Codes.so that if you don't know the code of the company you can see it in the list and pick it but only the code shows in the cell I hope that made sense. Thank you Hi Sounds like a job for a Combo Box with the Column Count set to 2 Brian There is a sample file here: http://contextures.com/excelfiles.html#DataVal Look for: DV0005 - Data Validation "Columns"  SignatureBiff Microsoft Excel MVP > Hello > Through Data > Validation, I've created a drop down list for a column to [quoted text clipped - 10 lines] > I hope that made sense. > Thank you Thanks I'll give it a go J > There is a sample file here: > [quoted text clipped - 16 lines] >> I hope that made sense. >> Thank you Good luck. Thanks for the feedback! SignatureBiff Microsoft Excel MVP > Thanks I'll give it a go > J [quoted text clipped - 19 lines] >>> I hope that made sense. >>> Thank you It was perfect Thank you very much > Thanks I'll give it a go > J [quoted text clipped - 19 lines] >>> I hope that made sense. >>> Thank you |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.