Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Israel
    Posts
    10
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I have a standard daily worksheet where I enter the various customers names and some information about the orders. I only have about 20 customers but they have long names. I would like to grab the customer-name from some list or look up in a list. Really much rather autocomplete.

    How do I do any of this?

    Thanks.
    Michael

  2. #2
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Do you already have a list of names? on a worksheet?

    Are you trying to accomplish in code?

    Thanks,
    Darryl.

  3. #3
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Michael Unger View Post
    I have a standard daily worksheet where I enter the various customers names and some information about the orders. I only have about 20 customers but they have long names. I would like to grab the customer-name from some list or look up in a list. Really much rather autocomplete.

    How do I do any of this?

    Thanks.
    Michael
    One simple approach is to use data validation OR vlookup, if you are having a list of names. Pl have a look.
    Attached Files Attached Files
    Regards
    Prasad

Posting Permissions

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