Worsheet and workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ta
with the ctrl key held. One simple formula will add all your invoices
Copy that same formula to get all other totals. Easier to contro
invoice numbers. Have all price lists, all customer codes, all paymen
terms in the one file, etc, etc etc

The main problem is what is the limit to how many invoices will you b
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 the
copying completed sheets multiple times and seeing how many you ca
create before performance is affected. Worth a try because this is th
simplest path.

There are macro-based ways of extracting information from multipl
files which are in exactly the same structure in the same directory, s
this is the next best option
 
Back
Top