Group by rows when the cell is not empty

**emina002** · 03-20-2013, 12:08 AM

Hi there, I am hoping someone could help me please

, I want to create a macro where I can group by rows when the cell is not empty, see attach file that from column C to N there is number from 1 to 12 and I want to group it when there is a each word found starting column C

. How can I achieve this??thank you so much

**arlu1201** · 03-20-2013, 06:59 AM

You need to explain some more. Maybe attach a sample output file.

**emina002** · 03-20-2013, 09:14 PM

Kindly refer to "Actual Output grouping 3level" tab for sample. If you notice in row 1 it has numbering which correspond on how many groupings will be done.Hope you understand me

**emina002** · 03-20-2013, 09:32 PM

I just need to select/highlight the empty cell from column D and perform group/ungroup

**arlu1201** · 03-24-2013, 06:12 AM

I am not able to understand your question. Maybe you can try explaining in a different way.

**emina002** · 04-01-2013, 05:05 AM

Ok I have the code already to group and ungroup each column, and groupings level has a limit of 8 or 7 only. Here is the workbook try to run macro 1st group the column C and D, when I group the Column E,Column D became messy

. If you notice the column D after you run the macro to group column E, the blank above the word "Total Assets" also include to groupings so when,ok I don't know if you get my point since it is hard to explain this problem,and this I do have the macro code so I think you get it now? Thank you