YTD tally of multiple values that are reset daily.

I have a workbook that is used for inventory tracking, and I need to keep a year to date tally of several fields. The data (numbers) in these fields are reset on a daily basis so I can't figure out how to lock the sum and add to it as the fields are populated.
On page 1, I have a matrix of parts. Not all parts are used daily, but all useage fields are reset daily with a macro.
On page 2, I need to tally the useage data.
I need the useage data to be summed and entered into page 2 as a running tally as fields are populated. Example: day 1 - part 1 useage is 4, the tally will read 4, day 2 - part 1 useage is 6, the tally will read 10, etc., etc.
All help will be greatly appreciated.

Joe

Hello Joe,

Welcome to the Forum!

It would be a big help if you could post your workbook or a sample of the worksheet layout. You don't mention if have used any formulas or other macros in project. Let us know and we can help you more.

Thanks,
Leith Ross

Leith,

I can't attach a .xls file to the post. Is there some other way to show you what I am trying to do?

Joe

Hello Joe,

The forum will only accept a workbook as an attachment if it is zipped, and under 100kb. If your workbook exceeds 100kb, you may have to create a new workbook with less data to post it.

Sincerely,
Leith Ross