Blank row

[excel2000]

I'm entering numbers under a colum, I need the total sum of the colum;
But after I enter the last number 221 and press enter it always needs
to skip with a blank row or cell ? it does not mater how many rows I
enter, I need a blank cell before the total.

Thank you very much.
JA
ex:
123
222
111
221
---> Here is where I need the blank row allways
677 This is the total sum

File Attached: http://www.excelforum.com/attachment.php?postid=334735 (book1.xls)

 

[Debra Dalgleish]

You could use event code to add the new cells. The following code
assumes that the numbers are in column A. Right-click on the sheet tab,
choose View Code, and copy the code onto the module:
'====================================
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 1 Then
If Target.Offset(1, 0).Value = "" Then
Application.EnableEvents = False
Target.Offset(1, 0).Insert Shift:=xlDown
Application.EnableEvents = True
End If
End If
End Sub
'====================================