Macro to Group Rows Along a Range Based on Values in a Column

**JHCali** · 05-23-2010, 05:58 PM

I need a macro to group rows based on values in a specific column.

I have a dashboard with data from row 21 to row 5000. The cells in column GM have the following values: "Hide", "Not Hide", or are blank. The data is sorted based on values in columns A, B, and C. As a result, there is no inherent order to the "Hide" or "Not Hide" values in the cells in column GM.

I need a macro to go down column GM, and group any row where the value in column GM is "Hide". In some cases, only a single row will be grouped with a "+" sign. In other cases, consecutive rows will be grouped as such.

I want to go with grouping rather than filtering because with grouping, data hidden along the range of the dashboard is more readily accessible.

Any help would be greatly appreciated.

Thank you very much.

**foxguy** · 05-23-2010, 06:23 PM

JHCali;

I'm curious; what do you mean by "Group"?

**JHCali** · 05-23-2010, 06:41 PM

Originally Posted by foxguy

JHCali;

I'm curious; what do you mean by "Group"?

Hi Foxguy,

I am using Excel 2007. By group, I want the macro the accomplish what I would otherwise have to do by manually selecting individual or consecutive rows with a value of "Hide" in column GM, and going to the Data tab, selecting Group, then Group again. The Group feature in Excel ties a range of cells together so they can be expanded or collapsed.

**foxguy** · 05-23-2010, 08:06 PM

JHCali;

I'm constantly learning things about Excel.
Try This

Please Login or Register  to view this content.

**JHCali** · 05-23-2010, 08:20 PM

Foxguy,

Worked brilliantly! Thank you so much!

**ashutoshsingbal** · 08-26-2013, 10:53 AM

Foxguy,
i was trying to write a macro similar to above, but my requirement was that macro should group all the rows containing data below a blank cell. In the example, i wanted the macro to group rows 3, 4 & 6,7 & so on. Can you please guide me?
Group & Outline.JPG

**hlpplease** · 09-06-2013, 10:20 AM

Hey Foxguy, I need some help.

I ran your code but it stopped after the group command.
In other words, once the code grouped the first set of rows marked with hide it stopped running.