How do I tie multiple invoices into one master sheet, totaling the
"Totals" from each sheet and totaling them by month (for 2008).
A lot depends on the layout of your sheets. Am I correct in assuming
that there are several invoice totals and several invoice (month)
dates, one for each invoice, on each sheet?
If so are there a fixed number of rows between each Invoice total, and
each Invoice date.
Assuming the above is true then one way would be to create a formula
at the top of each sheet, for the sake of argument in A1, which
automatically calculates the total of all the individal 2008 invoice
totals, probably with a SumProduct formula. Then on your master sheet
have another formula which adds across the A1 totals on all sheets.
Having said all that, this sort of exercise is simplified
immeasurably, if at the time of creating the invoices you write away
the Invoice Date, Invoice Total and probably Invoice Reference number
for each invoice record to a master database sheet in a three column
table. It is far easier to analyse and total from a structured
database than from an unstructured series of individual invoices
dotted around numerous sheets. You'd need a VBA macro to do this of
course, but a single invoice template coupled with some VAB code to
write to a database would in my opinion be a better option.
Hope this helps.
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at
http://www.malcom-mac.com/nemo