View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Asoka Walpitagama - Brandix College IT Asoka Walpitagama - Brandix College IT is offline
external usenet poster
 
Posts: 15
Default 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