View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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