I want to improve my spreadsheet from accumulating entries in same cell using a single spreadheet. Please refer to my previous which came out successfull. thread:http://www.excelforum.com/showthread...ght=accumulate

I now have 2 spreadsheet files 1st for Daily Entries and 2nd Progressive Totals. Both files have identical formats.

How can I program it so that the while the Progress Totals file is closed, daily entries entered on the Daily Entrie file accumulates the corresponding cells in the Progress Total file?