I have small company and use excel for invoicing and save each worsheet from
a tempate as a new invoice (unique number). I was wondering is the a function
i can use to calculate all the running totals? All the total and tax etc are
in the same cell s but on different sheets. can I save the all to a workbook
or do i have to start again or keep opening them individully as i am doing at
the moment?

sorry for the long question.

There are definite advantages to having all your invoices in one file.
Creating a new invoice is a simple dragging of a master worksheet tab
with the ctrl key held. One simple formula will add all your invoices.
Copy that same formula to get all other totals. Easier to control
invoice numbers. Have all price lists, all customer codes, all payment
terms in the one file, etc, etc etc

The main problem is what is the limit to how many invoices will you be
able to hold in one file. A year's? a month's? a week's? (you wish).
You can test this by creating your file, and in a test version then
copying completed sheets multiple times and seeing how many you can
create before performance is affected. Worth a try because this is the
simplest path.

There are macro-based ways of extracting information from multiple
files which are in exactly the same structure in the same directory, so
this is the next best option.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=534100