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,078,486
Messages
5,340,616
Members
399,387
Latest member
amrita34

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top