Thread: Sort pages?
View Single Post
  #5   Report Post  
Old May 12th 05, 09:43 AM
Posts: n/a

Dave Peterson wrote

Did you use Data|Subtotal to add the =subtotals()?

If yes, then I'd remove those subtotals, add the new person, sort the
data and reapply data|subtotals.

If you do this lots of times, you may want to record a macro when you
do it.

No, I didn't. I just put =Subtotal() formulae in desired cells.
Thanks for the input.