Hi Experts,
Once again, I have searched and I can't believe this is not out here, but I can't find it. So I am going to ask.
In the attached spreadsheet. I have a Macro that adds rows at certain intervals, based on a fixed value. I have the code adding in a sum at the inserts but it is not seeing the last blank as a place that needs the formula added.
Is there a way to get the sum formula to be dynamic in that it can adjust the start and end cells based on what would be the last "block" of data?
The spreadsheet has what I have so far, it is not pretty, but works, other than this.
The problem is in Column M in the spreadsheet, the very last line. The length will vary and this is just an example.
Thanks again for any help.
Bookmarks