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
No, I didn't. I just put =Subtotal() formulae in desired cells.
Thanks for the input.