How can I resize a level 2 grouping in a row-based outline structure.

Sid_Broach 

Thank you for clarifying your needs. It looks like you need a way to adjust the number of rows in each Level 2 grouping in an Excel outline to match the varying number of paydays in each month without having to recreate the entire outline structure.

Adjusting Level 2 Groupings in Excel

In Excel, there isn't a direct feature to resize specific outline groups dynamically. However, you can achieve your goal by using a combination of VBA to adjust the groups programmatically. This method allows you to change the grouping ranges without affecting other parts of your outline structure.

Here's a step-by-step approach to achieve this:

Using VBA to Adjust Groupings

1. Identify the ranges to be grouped/un-grouped.
2. Use VBA to dynamically adjust these ranges based on your specific requirements.

Below is a VBA script that you can use to adjust the groupings for a specified range dynamically. This example will show how to ungroup and regroup rows based on a specified number of rows for each group:

Step-by-Step VBA Solution

1. Open the VBA Editor:

• Press Alt + F11 to open the VBA editor in Excel.

2. Insert a New Module:

• In the VBA editor, insert a new module by right-clicking on any existing module and selecting Insert > Module.

3. Copy the VBA Code:

• Paste the following VBA code into the new module:

Vba Code is untested, Backup your file first.

4. Run the Macro:

• Close the VBA editor.
• Press Alt + F8 to open the Macro dialog box.
• Select AdjustLevel2Grouping and click Run.

Explanation of the Code:

1. Setting the Worksheet and Ranges:

• The ws variable sets the target worksheet.
• yearStartRow and yearEndRow define the range of rows for the year.

2. Looping Through Months:

• The macro loops through each month and adjusts the number of rows in the Level 2 grouping based on the predefined groupSize for each month.
• It then ungroups any existing groups in the specified range and applies new grouping.

3. Dynamic Group Sizes:

• You can modify the groupSize values to reflect the number of paydays for each month.

Customizing for Your Needs:

• Adjust the yearStartRow, yearEndRow, and groupSize values to fit your specific data structure and requirements.
• Change the sheet name Sheet1 to the actual name of your worksheet containing the data.

This VBA script provides a flexible way to adjust Level 2 groupings dynamically based on the number of rows you specify for each month, thus avoiding the need to recreate the entire outline structure from scratch each time. The text, steps and code were created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.