I have daily worksheets, which are contained in a monthly workbook. I have
daily numeric totals. On the end of the month worksheet, I need these daily
numbers (totals) to grand totaled. At the start of a new month, I begin this
process all over again with fresh worksheets...so I need to end up with
monthly totals, and ultimately...yearly totals. Every single day must have
its own worksheet, and every month will be a new workbook. What is the
formula to make daily totals cumulate onto the end of the month & year
worksheets?

Mahalo from Hawaii

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/consol.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm

The "Bread-Roll" consolidation method - great for accountants. See how
simple it is to consolidate any combination of your organisation's accounts,
daily or monthly. (No VBA used)


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-


"Daniel LEYVA" <Daniel wrote in message
...
I have daily worksheets, which are contained in a monthly workbook. I
have
daily numeric totals. On the end of the month worksheet, I need these
daily
numbers (totals) to grand totaled. At the start of a new month, I begin
this
process all over again with fresh worksheets...so I need to end up with
monthly totals, and ultimately...yearly totals. Every single day must
have
its own worksheet, and every month will be a new workbook. What is the
formula to make daily totals cumulate onto the end of the month & year
worksheets?

Mahalo from Hawaii