Excel Autofill contact info from previous times entered in


New Member
Mar 29, 2019
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!

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.


Board Regular
Apr 28, 2010
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.


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

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...