View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Insert New Row Automatically

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