Invoices

[Gordon Hughes]

Hi, I am using Excel to produce invoices for my son.
The one I have made up works well - Just insert "Prce per item, and Number,
then total price and tax are calculated by using formulae.
The only thing that slows the job is that I have to put in the customers
address. There are only about 40 of them, and I have them listed. Is there
any way I can use "Auto Complete" to insert the Address after I put in the
name ?
Or should I put the name/add in a database and impot them ?
Thanks for any help
Gordon

 

[JulieD]

Hi Gordon

i've put together a sample workbook that has an invoice template in it,
which also pulls in the customer's name from another sheet. If you'ld like
to email me direct (julied_ng at hcts dot net dot au) i'll happily send it
to you and you might be able to get some useful ideas from it.

Cheers
JulieD

 

[Debra Dalgleish]

You can use the VLOOKUP function to return the customer address after
you have entered the name. There are instructions in Excel's Help, and here;

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

To make it easy to enter the Customer Names, you can use a Data
Validation list. There are instructions here:

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