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