Hi

I have a worsksheet which i keep adding rows to. I have the 'total' of values in the rows in say row 20. So when i reach row 19 i am 'inserting new row' to take the 'total' row down one, and then do this again, and again everytime i add a value.

Is there a way to set it to automatically go down one row?

thanks