Results 1 to 3 of 3

Thread: Excel Autofill contact info from previous times entered in
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2019
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Excel Autofill contact info from previous times entered in

    I have a "Form" that I input a customers contact info in such as Name, company, city/state, phone, email. I would like excel to remember the name I typed in and when I go to type that name in again the contact fields will autofill with that persons information. is there anyway to do this or am I overthinking / overlooking the obvious? Please help!

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    167
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Autofill contact info from previous times entered in

    There are a couple ways to do this. All of which require some work. The easiest and most straight forward would be to use a sheet as a database of sorts, and add your contacts there along with any other information.

    Then, on your form, add code to catch changes to the control and have it do quick lookups for you. IF this sounds right, let me know and I think I can get you started.

  3. #3
    New Member
    Join Date
    Mar 2019
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Autofill contact info from previous times entered in

    yes thats what i was already thinking of doing but i was concerned with the way my sheet is set up that i wouldnt be able to add new contacts or i would have to pre add contacts to the new sheet.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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