View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Laura[_12_] Laura[_12_] is offline
external usenet poster
 
Posts: 1
Default Label the Groups

I have a spreadsheet with each row identified with a group name.

GrpName
Grp A
Grp B
Grp C
Grp B
Grp A
Grp C
Grp B

I have successfully built a macro to sort the data by the groups and put 3
blank rows between each group. So after the macro runs, it looks like this:


GrpName
<3 blank rows
Grp A
Grp A
<3 blank rows
Grp B
Grp B
Grp B
<3 blank rows
Grp C
Grp C

I'm creating client-ready reports, so I need to label each group with a
little descriptive sentence.

What I want to end up with is:

GrpName
<2 blank rows
The people in Group A are very nice.
Grp A
Grp A
<2 blank rows
The people in Group B are sometimes nice.
Grp B
Grp B
Grp B
<2 blank rows
The people is Group C are never nice.
Grp C
Grp C

I've been trying to get something to work all afternoon with all sorts of
interesting results. Any ideas?

Thanks in advance!