Excel question

[Robby]

I'm making a spreadsheet at work.

Its going to be updated through the month, with new rows being used. I want to have a totals row at the bottom.

So, what I want it to do is to insert a new row above the totals row every time the bottom empty row is full.

Clear? I hope it is.

I'm fiddling around with a macro at the moment, but I don't know the terminology to use for saying a row is full. I think the code in the macro should look something like: