Sort by Date, Add and Total Macro

L

Larry

I have 2 columns - "Date" & "Amount". In the "Date" column are daily postings for many years. In the "Amount" column are daily amounts postings for many years. I am trying to build a macro which, when activated by a custom button in the "Tools" menu, will automatically add accumulative amounts per month and display the monthly total in a row immediately beneath the last entry for any given month. i.e. "Total for January 2004 - $158,567.00". The "Total" statement entry should be highlited in yellow with a border around it. I know this is complicated but, I also know there are some Excel Masters out there with all powerful kung-fu. Thanks for your help!
 
Top