HELP PLEASE..Macro for rows

  • Thread starter Thread starter desperate in MS
  • Start date Start date
D

desperate in MS

I've search and search for an answer for this and no such luck.

Hope someone can HELP!!!!!

I have a excell speadsheet. Key data starts in "A10". I need something that
will automatically add/insert 3 rows once data is entered in "A10". Then when
data is again entered in "A13" (last row of the 3 added/inserted) I need 3
rows added/inserted and so on.
 
Try this. Right click sheet tab>view code>copy/paste this.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 10 Or Target.Column <> 1 Then Exit Sub
Application.EnableEvents = False
Target.Offset(1).Resize(3).EntireRow.Insert
Target.Offset(4).Select
Application.EnableEvents = True
End Sub
 
YOU ARE THE BEST...PERFECT....Showed my boss and that is exactly what he was
wanting....your the man
 
One more thing....column "c11" is highlighted.."c12" not highlighted. Enter
data in "c11" and get my next line at "c13" (what I'm wanting)...now I want
"c13" to be highlighted but not "c12" or "c14"....highlight everyother row
that has data....right now it is highlighting all the rows...any suggestions?
 
desperate in MS said:
One more thing....column "c11" is highlighted.."c12" not highlighted. Enter
data in "c11" and get my next line at "c13" (what I'm wanting)...now I want
"c13" to be highlighted but not "c12" or "c14"....highlight everyother row
that has data....right now it is highlighting all the rows...any suggestions?
Click to expand...
 
Back
Top