Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I create a customer database to use with an invoice?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make customer database with search engine by addy or name | Excel Discussion (Misc queries) | |||
How do I create a template that add the fields to a database? | Excel Discussion (Misc queries) | |||
linking customer database to invoices in excel | Charts and Charting in Excel | |||
Create database in excel? | New Users to Excel | |||
VB copde help - please! | Excel Discussion (Misc queries) |