Auto Insert NEw Row with formatting
 

I have an employee job list. I have Col. "B" as Employee Names. When I
click onto the cell (i.e. "B1") a drop down list appears with all the
employees names to pick from. This list is from the Master Employee Record
workbook. When I pick on a name it will automatically fill in all the cells
with formulas across the board and cells are linked to the cells that I type
in the hrs. This way all required taxes are atuomatically figured out. So
the question is this....As soon as I click the name from the drop down list I
want an "Entirely New Row Inserted" across the board directly under the name
I just picked.

Thank in advance

Greg

Auto Insert NEw Row with formatting
 

Post your existing code for comments and suggestions

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Greg" wrote in message
...
I have an employee job list. I have Col. "B" as Employee Names. When I
click onto the cell (i.e. "B1") a drop down list appears with all the
employees names to pick from. This list is from the Master Employee
Record
workbook. When I pick on a name it will automatically fill in all the
cells
with formulas across the board and cells are linked to the cells that I
type
in the hrs. This way all required taxes are atuomatically figured out.
So
the question is this....As soon as I click the name from the drop down
list I
want an "Entirely New Row Inserted" across the board directly under the
name
I just picked.

Thank in advance

Greg

Auto Insert NEw Row with formatting
 

Right click sheet tabview codeinsert this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 9 Or Target.Column < 2 Then Exit Sub
Rows(Target.Row + 1).insert
Application.EnableEvents = False
myname = Target
Rows(Target.Row - 1).Copy Rows(Target.Row)
Target = myname
Application.EnableEvents = True
Cells(Target.Row, "f").Resize(, 12).ClearContents
Application.CutCopyMode = False
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Greg" wrote in message
...
I have an employee job list. I have Col. "B" as Employee Names. When I
click onto the cell (i.e. "B1") a drop down list appears with all the
employees names to pick from. This list is from the Master Employee
Record
workbook. When I pick on a name it will automatically fill in all the
cells
with formulas across the board and cells are linked to the cells that I
type
in the hrs. This way all required taxes are atuomatically figured out.
So
the question is this....As soon as I click the name from the drop down
list I
want an "Entirely New Row Inserted" across the board directly under the
name
I just picked.

Thank in advance

Greg