Excel Multiple Sheet help!

Question

I have a workbook with multiple sheets. The sheets have employee numbers, names, hire dates, number of hours and termination date (if applicable). The only unique thing is the employee number. I have to update the current number of hours each week, which I am doing manually right now. I use a report exported out of our database into excel format to get the updated hours. The names are constantly changing as we will have employees that get terminated and therefore will not have hours, or we have brand new employees so I can't use the "sum to cell" method where you add together same cells on different sheets. I'm wondering if I can use the unique employee numbers to find the employees that have hours and then use a formula to update a certain column. Example below:

Above is from the spreadsheet. TW ID is the employee number.

Above is from the report from our database. Aident is the employee number.

Keeping in mind that these are two separate sheets, my question is, can I use column A (employee number) on Sheet 2 (report from database) to find the same column A (employee number) on Sheet 1 (spreadsheet) and THEN (if the employee number is found on both sheets) add together the "hours" in column E on Sheet 1?

Answer 1

I have a workbook with multiple sheets. The sheets have employee numbers, names, hire dates, number of hours and termination date (if applicable). The only unique thing is the employee number. I have to update the current number of hours each week, which I am doing manually right now. I use a report exported out of our database into excel format to get the updated hours. The names are constantly changing as we will have employees that get terminated and therefore will not have hours, or we have brand new employees so I can't use the "sum to cell" method where you add together same cells on different sheets. I'm wondering if I can use the unique employee numbers to find the employees that have hours and then use a formula to update a certain column. Example below:

Above is from the spreadsheet. TW ID is the employee number.

Above is from the report from our database. Aident is the employee number.

Keeping in mind that these are two separate sheets, my question is, can I use column A (employee number) on Sheet 2 (report from database) to find the same column A (employee number) on Sheet 1 (spreadsheet) and THEN (if the employee number is found on both sheets) add together the "hours" in column E on Sheet 1?

Hi,

Please check whether the following solution is helpful:

In Sheet2 >> formula in cell E2 is: =SUMIF(Sheet1!A:A,Sheet2!A2,Sheet1!E:E)

NOTE

1. In the above suggested formula, please change worksheet name/cell reference/ranges to suit Your requirement.

2. Please drag the formula down to more rows.

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Answer 2

YES!!!!! This worked. Thank you SO much!