Scott, This doesn't help me. I need to insert a line when the condition
changes. For example, this is what input spreadsheet looks like.

AAA 20
AAA 30
AAA 40
BBB 20
BBB 35
BBB 15
BBB 25
CCC 25
CCC 25
CCC 25

This is what I am trying to get to.
AAA 20
AAA 30
AAA 40
Subtotal AAA 90
BBB 20
BBB 35
BBB 15
BBB 25
Subtotal BBB 95
CCC 25
CCC 25
CCC 25
Subtotal CCC 75
Total 260

I am trying to avoid manual interventon and want to be able to automatically
break on the change and insert a subtotal row.
Have you goy any thoughts on this?
Smitty


"porter444" wrote:

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?