Auto-fill

Hello All,
I want to first off introduce myself as Mike, I am a shipping manager for a machine shop in Waukesha, WI. I have produced a 7-worksheet Microsoft Excel Template to make it easy for me to fill out all customs paperwork such as the Commercial Invoice, Certificate of Origin, NAFTA Cert of Origin, SED, Bugwood Certification and a NON-Wood Certification.

Point of my thread is I would like to find a way to have a "Drop menu" so to speak in the spot where I have to fill in the customer's name. Is that possible? For the times that I ship to specific locations on a regular basis, instead of writing the company name, street address, city, country, postal code etc....it would just auto fill once I start typing the name.

I hope that explains my request accurately, any help is greatly appreciated! Thanks.
-Mike

Hello Mike

To create a drop down menu with the customers I would use data validation. First you will need a database of all the customers.

Select the column that contains the names of the customers. then got to the menu bar and select "Insert/name/define" and type in a name (i.e. customers) and click "OK"

Next go to the cell or cells where you want the drop down. select the cells you would like and go to data/validation. under allow change it to list, make sure the "in-cell dropdown" box is selected and for source use =customers (or what ever you named it)

To get the address to fill in you will use a VLOOKUP formula. it will be something like this

=VLOOKUP(A1,Sheet1!B:C,2,)
where A1 is cell with the dropdown
Sheet1!B:C is the entire customer database
and 2 will reference the value that is in the second column of that database