Yann
08-25-2011, 10:19 PM
Hi All,
Need some help on this little problem....
I've got 4 columns in a spreadsheet (nb of lines will vary as well as the number of types):
Type Prduct ID Qty Value A ABC 1 100 A BVF 2 250 B RTT 1 350 D RWW 2 22 D IIU 5 54
What I need to do, is to insert a blank line above each type (group) and one after each type so I can insert subtotals. Excel built-in subtotals do not allow me to insert blank lines above the group.
Can someone help?
Thanks a lot
Yann
Need some help on this little problem....
I've got 4 columns in a spreadsheet (nb of lines will vary as well as the number of types):
Type Prduct ID Qty Value A ABC 1 100 A BVF 2 250 B RTT 1 350 D RWW 2 22 D IIU 5 54
What I need to do, is to insert a blank line above each type (group) and one after each type so I can insert subtotals. Excel built-in subtotals do not allow me to insert blank lines above the group.
Can someone help?
Thanks a lot
Yann