If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Short listing the Data Validation List
I have over 4000 entries as the prd code & need to enter them on a worksheet.
By using DATA VALIDATION is there a feature to shortlist the list when typing letters. ( Like a LOV ( List of values in Oracle Forms )) When "C" is types only the codes starting with C will be shown |
#2
|
|||
|
|||
Short listing the Data Validation List
Try this.
Sort your validation list and at the beginning of the A's enter a single A, do the same for the beginning of the B's and all the way through to the Z's. Click in the cell that has the drop down validation and type in the letter of the list you desire... say you type in an O. DO NOT hit enter... leave the cell in the edit mode (still selected) and now hit your down arrow. Should take you to the O which is the top of the O list of selections. HTH Regards, Howard "Asoka Walpitagama - Brandix College IT" osoft.com wrote in message ... I have over 4000 entries as the prd code & need to enter them on a worksheet. By using DATA VALIDATION is there a feature to shortlist the list when typing letters. ( Like a LOV ( List of values in Oracle Forms )) When "C" is types only the codes starting with C will be shown |
#3
|
|||
|
|||
Short listing the Data Validation List
You can use a combo box from the control toolbox toolbar. It has
autocomplete capabilities. -- Biff Microsoft Excel MVP "Asoka Walpitagama - Brandix College IT" osoft.com wrote in message ... I have over 4000 entries as the prd code & need to enter them on a worksheet. By using DATA VALIDATION is there a feature to shortlist the list when typing letters. ( Like a LOV ( List of values in Oracle Forms )) When "C" is types only the codes starting with C will be shown |
Thread Tools | |
Display Modes | |
|
|