See Excel help on the SUBTOTAL function. It does change with filters. Very
handy.

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"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?