I've got this really long macro that does exactly what I want, but a large chunk of the code at the end seems repetitive to me. But it was the only way I could figure to do what I need. I'm just wondering if some of it could be consolidated.
I'll attach my practice workbook with a sheet before the macro runs at all, a second sheet where I've only run the macro to just before the repetitive part and a third sheet showing after the whole macro runs.
Basically, what I have it doing is adding a total at the end of each section in "Account Activity Details", then adding a formula in H & I of the "Grand Total" row to sum up all of the section totals. Then, just below that, it adds a formula in I to sum up those totals. I had to designate the start of each section, then refer to the cells before or after them to tell it where to put the section totals. I can't refer to specific row numbers, because, naturally, the reports are different lengths each month.
If this is already a good way to do it, then I'm fine with that, but if there's something more efficient, that'd be good too.
Below is that part of the code:
Thanks!Please Login or Register to view this content.
Jenny
Bookmarks