Dear Friends,

I have a spreadsheet similar to the following:

Symbol Trans Shares
1 AMD Buy 100
2 AMD Buy 50
3 AMD Buy 200
4 DELL Buy 300
5 DELL Buy 100
6 DELL Sell 500
7 DELL Sell 400
8 DELL Sell 600

I want to write code that will insert two rows and put in a subtotal for the
shares
every time either the value in the Symbol column OR the value in the Trans
column changes.

Thus, I would like to put in a subtotal after row 3, because the Symbol
changes from "AMD" to "DELL".

There should also be a subtotal after row 5 because the Trans changes from
"Buy" to "Sell".

I can write the code that inserts the two lines and creates the subtotal. I
just can't write the code that figures out that this needs to be done after
row 3 and after row 5.

Thanks,
Alan


--
achidsey