Regarding accompanying spreadsheet.
As you can see, data entry is not going to be consistent. But existing formulas summarize a month's worth of data into a single entry in the far left section.
However, if a "rogue" date is entered (in this case, March, 2013) it does, indeed, summarize it and make an entry in the far left section.
BUT...I'd like to keep those summaries in chronological order from bottom-up. Spacing isn't significant since each month has only one entry at most in the left section and if March, 2013, is immediately above Nov, 2012, that's ok. When data is entered BETWEEN Nov and March it will (or should) move March up one row (at least) to accommodate the new dates (those entered between Nov and Mar).
Any ideas? (BTW, Excel 2010)
CANNOT USE MACROS--some clients will not allow spreadsheets to run if they contain macros.