+ Reply to Thread
Results 1 to 4 of 4

Autocomplete list

  1. #1
    Forum Contributor
    Join Date
    01-19-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2016
    Posts
    133

    Autocomplete list

    In worksheet "27.07" I have a list in cell A2. Her reference is worksheet "operatori".
    How can I do when I select A2 list, typing - to say the first two digits - and to defend my list matches what I typed.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,105

    Re: Autocomplete list

    What do you want to happen in the operatori sheet when you select a code in the drop-down list? Please show expected results in your workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    01-19-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2016
    Posts
    133

    Re: Autocomplete list

    I WANT IN SHETT "27.07" If i type 01 in the list THEN IN THE LIST I find 0127, 0112, 0116 VALUE. Then i chose what value wanted.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,105

    Re: Autocomplete list

    You may need a VBA solution, as drop-down boxes are not smart like that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 04-22-2014, 03:30 PM
  2. Autocomplete from List on another sheet
    By ChrisMattock in forum Excel General
    Replies: 2
    Last Post: 07-10-2012, 11:00 AM
  3. Autocomplete using dropdown list
    By kevinf5 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-24-2010, 08:17 AM
  4. autocomplete from list
    By sick stigma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2009, 03:54 AM
  5. List with autocomplete
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2008, 02:34 PM
  6. Autocomplete from a list on the worksheet
    By mrdata in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2006, 04:11 PM
  7. [SOLVED] How to clear autocomplete list
    By Gregg Hill in forum Excel General
    Replies: 5
    Last Post: 02-08-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1