I have been working on this macro for a little and got stuck, wondering if anybody has any suggestions. Ill post the code and the output below for reference.
Excel Output & Code - Album on Imgur
Everything under the last row with a category name in all caps ("CONTINGENCY" in this case) needs to be removed. This macro will be used on other sheets as well, where the last category name could be something different next time. However, the cut off will always be the last category name formatted with all caps.
The goal of this macro is to create a one click solution to extracting specific data from a much larger spreadsheet into the table pictured, which is formatted this way because it matches our report style. The category names that aren't all caps are sub-categories and aren't needed in the report.
I do not want to do a pivot table. Looking for one or two lines of code I can add to what I already have in order to achieve this, if possible.
I am also open to suggestions on how to simplify what I have written so far.
Thanks!
Excel Output & Code - Album on Imgur
Everything under the last row with a category name in all caps ("CONTINGENCY" in this case) needs to be removed. This macro will be used on other sheets as well, where the last category name could be something different next time. However, the cut off will always be the last category name formatted with all caps.
The goal of this macro is to create a one click solution to extracting specific data from a much larger spreadsheet into the table pictured, which is formatted this way because it matches our report style. The category names that aren't all caps are sub-categories and aren't needed in the report.
I do not want to do a pivot table. Looking for one or two lines of code I can add to what I already have in order to achieve this, if possible.
I am also open to suggestions on how to simplify what I have written so far.
Thanks!
