Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
Moving Data from Template | Excel Discussion (Misc queries) | |||
Excel merge or data form (for invoice)..help!! | Excel Worksheet Functions |