I need help with some VBA to loop through a spreadsheet and Group rows with an indent level > 0. Indent level 0 is the highest level summary for the data, detail is broken out at indent level 1, 2 etc.. A data sample follows:
Cash & Short Duration
Cash and Money Market
Money Market 1
Money Market Fund 2
Fixed Income
Corporate Bonds
Corp Bond Holding 1
Corp Bond Holding 2
High-Yield Bonds - Taxable
HY Fund 1
HY Fund 2
In this example I need to Group "Money Market 1" + "Money Market 2", and then also group "Cash and Money Market" + "Money Market 1" + "Money Market 2" at the next level. This would allow for two levels of outline functionality to roll up data. My data set does not have formula subtotals so the Auto Outline feature doesn't work here. The data is however indented at each level. Many thanks in advance for any tips to solve the coding challenge.
Cash & Short Duration
Cash and Money Market
Money Market 1
Money Market Fund 2
Fixed Income
Corporate Bonds
Corp Bond Holding 1
Corp Bond Holding 2
High-Yield Bonds - Taxable
HY Fund 1
HY Fund 2
In this example I need to Group "Money Market 1" + "Money Market 2", and then also group "Cash and Money Market" + "Money Market 1" + "Money Market 2" at the next level. This would allow for two levels of outline functionality to roll up data. My data set does not have formula subtotals so the Auto Outline feature doesn't work here. The data is however indented at each level. Many thanks in advance for any tips to solve the coding challenge.