| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Address in Excel invoices
I have been doing my invoicing through Word and want to change to Excel but
cannot find how to automatically enter addresses of my clients. Can anyone help please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Address in Excel invoices
What do you mean by AUTOMATICALLY enter addresses .... as in the WORD "Mail
Merge" type function? "Not Just Talking" wrote: I have been doing my invoicing through Word and want to change to Excel but cannot find how to automatically enter addresses of my clients. Can anyone help please? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Address in Excel invoices
Probably by using a lookup and VLOOKUP formulas which return the addresses based
upon an ID number or similar. 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 On Thu, 10 May 2007 05:20:00 -0700, Not Just Talking wrote: I have been doing my invoicing through Word and want to change to Excel but cannot find how to automatically enter addresses of my clients. Can anyone help please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| On Excel Invoices it gives an invoice number-can be seq #'d??? | Excel Discussion (Misc queries) | |||
| Auto number invoices in Excel | Excel Worksheet Functions | |||
| Will Excel produce invoices from a spreadsheet? | Excel Worksheet Functions | |||
| IS THERE A WAY TO TRACK INVOICES IN EXCEL AUTOMATICALLY? | Excel Discussion (Misc queries) | |||
| Create invoices from excel workbook | Excel Worksheet Functions | |||
Hybrid Mode
