Results 1 to 2 of 2

Thread: Auto Complete for Data Validation

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-14-2013, 06:40 PM #1
    IJC
    IJC is offline
    Junior Member
    Join Date
    May 2013
    Posts
    4
    Rep Power
    0

    Auto Complete for Data Validation

    Hi

    How do I have the name appear in the cell C2 (sheet1) from the dropdown list : Example if I type the letters "am" in cell C2 (sheet1) then the name Armandip Sharda should appear and when I hit enter then the name is selected.When letters are typed in C2 (sheet1) then the most appropriate name appears

    Thanks

    IJC
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Custom Data Validation :: Using Formulas
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-04-2013, 05:40 PM
  2. VBA Stop Workbook From Closing Unless Data Is Filled Complete
    By MATRIXOFFICE in forum Excel Help
    Replies: 22
    Last Post: 03-19-2013, 07:57 AM
  3. Auto filter and sum up data
    By Ryan_Bernal in forum Excel Help
    Replies: 6
    Last Post: 01-02-2013, 06:42 PM
  4. Dependent Data Validation (Using Only Formulas)
    By Admin in forum Download Center
    Replies: 2
    Last Post: 10-18-2011, 03:14 PM
  5. Data Validation Dependent Dropdowns
    By Admin in forum Download Center
    Replies: 0
    Last Post: 04-10-2011, 03:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules