Add new row to table for data that matches the reference cell

[lemahs]

Hi,

I'm new to MrExcel.com, but not unfamiliar. I've been searching for a solution for a work related problem for months, but still no dice. So I'm hoping that this community can help me find one. I'll try to keep this as simple as possible.

• Right now the employee number (column C) and employee name (column D) are manually entered.
• A sumifs formula (column E) totals all the approved hours in (column AB) of the "Billing" worksheet of an employee using the reference job ID in cell B1 of the active worksheet "Project 1"
• I'm looking for a formula, macro or whatever works that can:

• Find all the employees that have billed to a referenced job code
• insert a new row and fill in the name and number of the employee at the bottom of the table
• Copy the formulas from the above row

Other info:

• Each job will be on a separate tab (i'm looking into options to have all jobs on one worksheet and then grouping that data) - might be too cumbersome
• What you see below is a condensed version of the full worksheet, but should give you enough detail
• The data in the "Billing" worksheet is data output from a ERP system, the format of the data really won't change, different columns may be added but that's about it

Please see the attachment in the dropbox link here: https://www.dropbox.com/s/p6jzcpefpg1bdqi/BillingTemplate_test.xlsm?dl=0

Right now, adding employees to this table is done manually, and when there are a lot of jobs that a person can bill to, updating this can be very time consuming... so I'm hoping to avoid that.

Thanks community, hope you can help me out!!

 

[lemahs]

Any takers? No one at my job seems to be skilled enough so you guys/gals are really my best bet.