View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ana Ana is offline
external usenet poster
 
Posts: 44
Default Add new subtotal lines

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