Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing the font for part of an axis label, not the whole label. | Charts and Charting in Excel | |||
Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |