Excel has a built-in subtotaling tool. Go to Data Subtotals.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Smitty" wrote:

I am trying to create a worksheet from another. On the new worksheet I want
to insert a subtotal line based upon a change in client name. Can anyone
tell me how to do that?