Add new subtotal lines

[Ana]

Hi,
quick question on subtotals.

I have a huge list with subtotals and I need to know how I can insert new
subtotal lines.

For example, i have the following lines:
A
A
Subtotal A
C
C
Subtotal C

And I want to insert 3 new lines between A anc C for :
B
B
SubtotalB

I know I could remove subtotals, insert my new lines, and then re-run the
subtotals 'routine' again.. but was just wondering if there's a more elegant
way of inserting my new lines.

If this question has been asked before, just let me know - but just spent 10
min searching the 'archives' and I could't find a similar qustion.

Thanks!

AV

 

[Dave Peterson]

I would remove the subtotals, insert the lines, sort the data if necessary, and
redo the subtotals.

Another suggestion would be to use a pivottable against a dynamic range. So you
could add your data to the bottom of your range and then refresh the pivottable.

Debra Dalgleish explains dynamic range names here:
http://contextures.com/xlNames01.html#Dynamic

If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx