Loop to group data

[koticphreak]

I think I need a macro that is a for while loop that will group data for me...

I basically have a number of reports that go like this:
Blank line
data 1
data 2
data 3
data 4
BOLD data
Blank line
data 5
data 6
data 7
data 8
BOLD data
...etc

I basically would like to create a macro that groups all data and only leaves the 'BOLD data' visible when I collapse that grouping... so I would only see:
Blank line
------------
BOLD data

With the "---" signifying the hidden (grouped) data lines. I feel like this is fairly easy to create, just not sure where to start.

The pattern is consistent throughout the documents with only needing to look at column A for the bold/blank criteria, and it can stop as soon as it finds 2 consecutive blank lines.


Thanks in advance for any help!

[koticphreak]

No responses? I figured this would be easy... guess not

[cjo]

Hi,
Try this

Please Login or Register  to view this content.

[watersev]

hi koticphreak, option based on your example, run code "test"

[cjo]

watersev,
That's a nifty way of doing it.

[koticphreak]

Hate to bring a post from the dead, but watersev's post was a huge help and totally worked. However, now the data has gotten more complicated, and there is sometimes now a blank row right before the bold - so now I need something that will always group based on the bold, not the blank row. Other than that, all else is the same! Thanks in advance.

Also I will add (based on cjo's post) that the blank row is never set to bold, so no worry there.