| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel invoices and automated summary
Is there an Excel invoice template that automatically adds current info into
a year-to-date summary worksheet? What I'm looking for is an invoice that will automatically add the invoice total to another file listing weekly invoice amounts to create a year-to-date summary. |
|
#2
|
|||
|
|||
|
Hi CMacadams
You can run a macro to make a sheet with links to a cell in all workbooks. Try http://www.rondebruin.nl/summary2.htm Or http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CMacadams" wrote in message ... Is there an Excel invoice template that automatically adds current info into a year-to-date summary worksheet? What I'm looking for is an invoice that will automatically add the invoice total to another file listing weekly invoice amounts to create a year-to-date summary. |
|
#3
|
|||
|
|||
|
Thank you, Ron. Most helpful!
Jeannie "Ron de Bruin" wrote: Hi CMacadams You can run a macro to make a sheet with links to a cell in all workbooks. Try http://www.rondebruin.nl/summary2.htm Or http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CMacadams" wrote in message ... Is there an Excel invoice template that automatically adds current info into a year-to-date summary worksheet? What I'm looking for is an invoice that will automatically add the invoice total to another file listing weekly invoice amounts to create a year-to-date summary. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
