Auto filling name and address on invoice

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Candyman - 06 Sep 2007 23:14 GMT

I want to choose a name from a drop down box in cell D7 and then have cells
D10, J10, M10 auto fill with the correct street address, city and state
respectively. I don't know where to start.

Joe

Reply to this Message

Gord Dibben - 07 Sep 2007 00:23 GMT

Use a Data Validation dropdown for choosing the name.

VLOOKUP formulas will pull the data to appropriate cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

Note the section on using DV lists from another worksheet by naming the list.

Gord Dibben MS Excel MVP

>I want to choose a name from a drop down box in cell D7 and then have cells
>D10, J10, M10 auto fill with the correct street address, city and state
>respectively. I don't know where to start.
>
>Joe

Reply to this Message

Debra Dalgleish - 07 Sep 2007 00:23 GMT

You can use VLookup formulas to fill in the address information. There's
a sample here, that fills in parts of an order form based on user
selections from dropdown lists:

http://www.contextures.com/xlOrderForm01.html

> I want to choose a name from a drop down box in cell D7 and then have cells
> D10, J10, M10 auto fill with the correct street address, city and state
> respectively. I don't know where to start.
>
> Joe

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Candyman - 10 Sep 2007 03:00 GMT

I followed the links and downloaded the sample files, tried to recreate them
as written and grounded out when I tried to add a customer list. I failed to
mention I was using XL2007 and step 8 stumps me, can't figure out how to
click add.

Further down in create customer dropdown and lookup, step 4, custList was
not available as a source. Thats where I am, could use further direction.

Signature

Joe

> I want to choose a name from a drop down box in cell D7 and then have cells
> D10, J10, M10 auto fill with the correct street address, city and state
> respectively. I don't know where to start.
>
> Joe

Reply to this Message

Debra Dalgleish - 11 Sep 2007 22:24 GMT

Did you download the sample file? It might help you see how the order
form works.

In Excel 2007, for step 8, click OK, to close the dialog box.
Then, on the Ribbon, click the Formulas tab, and click Define Name.
Create the next name, CustLookup, as described in the instructions.

After you create the CustList name, you should be able to use it in the
data validation dialog Source box: =CustList

> I followed the links and downloaded the sample files, tried to recreate them
> as written and grounded out when I tried to add a customer list. I failed to
[quoted text clipped - 3 lines]
> Further down in create customer dropdown and lookup, step 4, custList was
> not available as a source. Thats where I am, could use further direction.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message