Subtotal

[Guest]

I have a list of names which I've subtotalled by region (using Data-Subtotals) . Now that I have new regions to add to the list, is there a way for the subtotal to update itself to include these regions without having to remove all the subtotal and do it all over again.

Thank you!

 

[Frank Kabel]

Hi
AFAIK you have to re-create the subtotals. you may record a macro while
doing this so for further additions you just can invoke this macro

 

[Dave Peterson]

You may want to consider a pivottable with a dynamic range to adjust to
additional entries.

And then you'd only have to refresh the pivottable to see your new results.

Debra Dalgleish has some notes for dynamic range names:
http://www.contextures.com/xlNames01.html#Dynamic

Here are some links for pivottable info:

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/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