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.

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" <[email protected]> wrote in message news:[email protected]...
> 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.

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" <[email protected]> wrote in message news:[email protected]...
> > 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.
>
>
>