Automatically filling cells after selecting from drop down menu [Solved]

Automatically filling cells after selecting from drop down menu

I am trying to create a form in excel.
I have created a drop down menu of last names..
the first thing I want to do is when starting to type the last name excel automatically finds your options..
for example if last name is Robertson..
and I start to type
R..
it will automatically give you options until you find the correct name.
Then once the name is selected..
I would like the rest of the cells to autofill.
I have Lastname, Firstname, Mailing address, State, Zip, Phone number...
all in columns in Sheet2.
I am creating my form in Sheet1. I tried using VLookup but am under a time crunch.
Any help would be greatly appreciated! :D
Thank you, AKadminassistant

Anwsers to the Problem Automatically filling cells after selecting from drop down menu

Download Error Fixer (Free)

Don't Download Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.

Don't install download manager

Many sites suggest or require you to install an installer or a download manager before allowing you to download a program you may be interested in downloading. These tools almost always cause your computer more problems and may even have malware or other spyware. Avoid any site claiming anything must be installed first before you can continue with your download.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Recommended Method to Repair the Problem: Automatically filling cells after selecting from drop down menu:

 

 

How to Fix Automatically filling cells after selecting from drop down menu with SmartPCFixer?

1. Download Error Fixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.

Related: Action Center On My Computer Stopped Working About A Week Ago. It Won't Open.,"Atheros AR9485WB-EG Wireless Network Adaptor Is Experiencing Driver Or Hardware-related Problems" How Do I Fix This?,4 Questions On Restore Files And Recover System,Allowings One Person To Access A MS Access Database At A Time,Arrow Cursor On Desktop Screen,0 Is Showing As A Result Of Formula,Win 7 Backup And Restore Program Content Question,Windows 7 Will Only Start In Safe Mode!,Windows Was Unable To Create A Required Instillation Folder Error 0x80070005,Presentation Mode Is Always On When I Turn On My Computer. My Desktop Icons Are Gone And The Computer Seems To Run Slower.,Title Of Saved File,How Can I Change My E-mail From Windows Live Mail To Yahoo Mail? Whenever I Try And Send Something In Windows Mail It Tells Me It's The Wrong Server.,How To Merge/delete Networks In Windows 8/8.1 ? The Option Is Missing Here.,When I Use Hibernate Mode For More Than 2 Days I Can't Load Windows 7 Home Premium,Display Driver Has Stopped Working And Has Recovered Error
Read More: [Anwsered] how can i access my msn account? I have had my email and password for years and now I can't get into it! Why? i am finding no help from windows live,Solution to Error: look for same ref. in second spreadsheet and return info from several rows into one cell in 1st spreadsheet.,Solution to Error: Problem Reports and Solutions,Summing hours:minutes in PivotTable [Solved],Solution to Error: Windows 7 USB Drive with RAW partition.,Pc does not meet security requirements when trying to connect the computer remotely,IE 11 options under Security -- Internet Zone is locked,matlab 2007 windows 7 incompatibility,Windows 7 compatibility not working,homegroup setup fails