Thread
:
How can I create a customer database to use with an invoice?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
Posts: n/a
How can I create a customer database to use with an invoice?
Brenda
You can use a series of VLOOKUP formulas and a Lookup table to return customer
info to various cells based on the entry of an ID number.
Check out Help on creating a Lookup table and using the VLOOKUP Function.
Also visit Debra Dalgleish's site for more on Data Validation drop-down lists
and VLOOKUP formulas.
http://www.contextures.on.ca/xlDataVal01.html
http://www.contextures.on.ca/xlFunctions02.html
Gord Dibben MS Excel MVP
On Tue, 25 Apr 2006 09:04:02 -0700, Brenda L. Carroll <Brenda L.
wrote:
I would like to create a database of clients in Microsoft Office 2003 in
order to merge with an invoice without typing the customer information
everytime I need an invoice. I would like to be able to enter the client ID
#, which would import all the client mailing information I need for the
invoice.
Gord Dibben MS Excel MVP
Reply With Quote