Is there an excel function that automatically add rows if preceding cells contains a formula resulting to >0?

Question

If there is none show me the VB code instead.

ex. A4 is grand total of A1:A3, if A3 contains value greater than 0 then would add row after A3. added row must also contain formula of preceding row. There would still be rows for grand total. Thank you people of the world!!! Making things easier for us. :-)

Answer 1

If you want a reasonable answer to this question you will need to extend it and explain it.  

It sounds like you are saying that if A3 is positive a new row must be added between row 3 and row 4 and the new row will be the same as row three si that the test is applied to the new A4 which is positive so that a new row must be added and so on forever.

I don't think that is what you meant.  So please provide more explicit examples of what you do mean.  Thanks