ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Can I merge data of 200 clients into an invoice template? (https://www.excelbanter.com/new-users-excel/74394-can-i-merge-data-200-clients-into-invoice-template.html)

Gail

Can I merge data of 200 clients into an invoice template?
 
I have 200 clients data and I need to produce a monthly invoice for them. Can
I merge into a template that will also number each invoice with me having to
do it?

CLR

Can I merge data of 200 clients into an invoice template?
 
Yes, assuming you have a standard template for billing, you must write a
custom macro to choose each clients data in succession and apply their data
it to the appropriate cells in the template, and then either save or print
out the invoice.

hth
Vaya con Dios,
Chuck, CABGx3



"Gail" wrote:

I have 200 clients data and I need to produce a monthly invoice for them. Can
I merge into a template that will also number each invoice with me having to
do it?



All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com