Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoices
I have a worksheet for 37 addresses, showing various charges
I need to produce a single invoice for each address Any help please |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoices
"suewalton21" wrote in message
... I have a worksheet for 37 addresses, showing various charges I need to produce a single invoice for each address Any help please Use Mail Merge (Word) with your worksheet as the data source. Google for detailed instructions if needed. V |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoices
"suewalton21" wrote in message
... I have a worksheet for 37 addresses, showing various charges I need to produce a single invoice for each address Any help please Use Mail Merge (Word) with your worksheet as the data source. Google for detailed instructions if needed. V |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoices
If you have a database of your addresses and an invoice template you can use
a simple looping macro for i= 1 gto 37 with invoicetemplate ..cells(1,1)=cells(i,1) ..etc end with print invoice next i -- Don Guillett Microsoft MVP Excel SalesAid Software "suewalton21" wrote in message ... I have a worksheet for 37 addresses, showing various charges I need to produce a single invoice for each address Any help please |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoices
Hi,
If you are looking to summarize the charges by address assuming that your data with your address are in column A and your charges in column B and then in column D you have all the address and in column E you want to summarize them use =sumproduct(--(D2=$A$1:$A$10000),$B$1:$B$10000) change range to fit your needs, copy formula down "suewalton21" wrote: I have a worksheet for 37 addresses, showing various charges I need to produce a single invoice for each address Any help please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
invoices | New Users to Excel | |||
invoices | Excel Discussion (Misc queries) | |||
Invoices | Excel Worksheet Functions | |||
how to set up invoices | Charts and Charting in Excel | |||
Invoices | Excel Discussion (Misc queries) |