Excel Autofill contact info from previous times entered in

[MrHydrant1857]

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!

 

[Steve_]

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.

 

[MrHydrant1857]

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.