need help with macro to autosum above values, multiple lines and ranges

[brianMNnonprofit]

Hi all,
I'm on Windows 7 and Excel 2010. I have a large spreadsheet of values with column a specifying each unique set (ie. zip codes). I've already ran a macro that inserted a line after each set and I need a macro to autosum values above each empty line.

Attached is a screenshot of the spreadsheet so you can see what I am starting with. I have data spanning up to row 3000 and data to autosum in columns E - AM.

All and any help is very appreciated!

(background: The few macros I've tried from this forum have either not worked or partially worked (the closest one would autosum the first set right, incorrectly autosum the first and second set together, and then skip the third, then repeat...)

 

[AOB]

Why not just use subtotals? Would save the need to insert blank rows in the firts place too...

 

[brianMNnonprofit]

Why not just use subtotals? Would save the need to insert blank rows in the firts place too...

brilliant! thanks!