I am setting up a Invoice and I want to be able to add a new row whenever the
second last one is used. ( the last one contains the totals )

ie: if row 22 is used then it creates a new row (using the same type of
format as before)
I know this is a easy task but I am still a beginner trying to lealn this
program I am not sure of how to do this task.

Thanks in advance

a) right click the number of the line (most left position on the line) and
click insert, or:
b)select the line and press CTRL plus the + Key

Both procedures will add you a new line, but if you want to add more than
one line at a time, select more than one line at a time and do like in option
a) above., e.g., if you want to add 4 lines at a time, select 4 lines and
press CTRL and the + key.


"Scott" wrote:

I am setting up a Invoice and I want to be able to add a new row whenever the
second last one is used. ( the last one contains the totals )

ie: if row 22 is used then it creates a new row (using the same type of
format as before)
I know this is a easy task but I am still a beginner trying to lealn this
program I am not sure of how to do this task.

Thanks in advance

Can't tell from your post which column is used for totals and how the data
gets entered but for example assume column A

Enter this formula in A2

=SUM(A1:INDEX(A:A,ROW()-1))

Paste this event code into your worksheet then start entering numbers in A1.

A row will be inserted and the SUM range will expand to include the new row.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
If Range("A" & n).Value < "" Then
Range("A" & n).Offset(1, 0).EntireRow.Insert
End If
End If
enditall:
Application.EnableEvents = True
End Sub

Right-click on your sheet tab and "View Code". Copy/paste the code into
that module. Edit to suit then Alt + q to return to the Excel window.


Gord Dibben MS Excel MVP

On Sun, 7 Sep 2008 16:39:01 -0700, Scott
wrote:

I am setting up a Invoice and I want to be able to add a new row whenever the
second last one is used. ( the last one contains the totals )

ie: if row 22 is used then it creates a new row (using the same type of
format as before)
I know this is a easy task but I am still a beginner trying to lealn this
program I am not sure of how to do this task.

Thanks in advance