Auto insert new row after current row filled in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI

I am creating a workbook that has a column for the name of the bill, a colum
for the ammount of the bill, and at the bottom of the ammount colum, a total.

I would like it to be so that every time i fill in the last row before the
total, a new row is generated so that i dont have to keep doing it manually.

for example:

electric 10
phone 21
cell 13
44
becomes

electric 10
phone 21
cell 13

44



Thank you
 
right click sheet tab>view code>insert this>SAVE. Now when you put a number
in col B above Total in col A the row will be inserted and your cursor will
goto col A on the inserted row.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Then Exit Sub
If Cells(Target.Row, 2).Offset(1, -1) = "Total" Then
Rows(Target.Row + 1).Insert
Cells(Target.Row + 1, 1).Select
End If
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill a column 3
Auto update row numbers after inserting new row 4
Automatically insert new rows 2
INSERTING NEW ROWS 3
Auto fill formulae when inserting rows 9
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Insert New Row 1
Insert New Row with auto formatting. 3

Back
Top