Excel Autofill contact info from previous times entered in

MrHydrant1857

New Member
Joined
Mar 29, 2019
Messages
14
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_

Board Regular
Joined
Apr 28, 2010
Messages
167
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

New Member
Joined
Mar 29, 2019
Messages
14
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.
 

Forum statistics

Threads
1,077,784
Messages
5,336,332
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top