brianMNnonprofit
New Member
- Joined
- Dec 6, 2012
- Messages
- 2
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...)
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...)