Prev: combining data in multiple cells
Next: Scheduling
From: suewalton21 on 15 May 2010 16:51
I have a worksheet for 37 addresses, showing various charges
I need to produce a single invoice for each address
Any help please
From: Victor Delta on 15 May 2010 19:08
"suewalton21" <suewalton21(a)discussions.microsoft.com> wrote in message
news:C4F900C5-EAF7-460D-A041-5CCE3B9FE23E(a)microsoft.com...
>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

From: Victor Delta on 15 May 2010 19:08
"suewalton21" <suewalton21(a)discussions.microsoft.com> wrote in message
news:C4F900C5-EAF7-460D-A041-5CCE3B9FE23E(a)microsoft.com...
>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

From: Don Guillett on 16 May 2010 08:29
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
dguillett(a)gmail.com
"suewalton21" <suewalton21(a)discussions.microsoft.com> wrote in message
news:C4F900C5-EAF7-460D-A041-5CCE3B9FE23E(a)microsoft.com...
>I have a worksheet for 37 addresses, showing various charges
> I need to produce a single invoice for each address
> Any help please

From: Eduardo on 17 May 2010 07:55
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
 | 
Pages: 1
Prev: combining data in multiple cells
Next: Scheduling