Robby Dirty Old Man
Joined: 16 May 2002 Karma :
|
Posted: 12:25 - 27 Feb 2006 Post subject: Excel question |
|
|
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:
Code: |
IF bottom row = 1
THEN Selection.Insert Shift:=xlDown
|
Also how do I make it so the macro is always active? |
|