Hi everyone,
I would appreciate it if someone can help me with this.
I have a workbook of 13 sheets. All 13 sheets contain the same information:Activity-Employee Code-Employee Name-Code1-Cost1-Code2-Cost2.
I'll show a small example to illustrate my case:
I have a table containing all Employees' Name and code
<tbody>
</tbody>
This Table is in Sheet1 of the same workbook.
Now Sheet2 Contains the following:
<tbody>
</tbody>
What I need to happen in this sheet is to extract all codes with the corresponding Employee Name and cost.
Let's Take for example Code 1020:
I need to have the following:
<tbody>
</tbody>
<tbody>
</tbody>
And then Having the Total Summary Table for both Cost (Cost1+Cost2)
<tbody>
</tbody>
By this the data for Sheet2 will be done.
Now if I jump to Sheet3 and do the same procedure, I'll end up with this total summary table :
<tbody>
</tbody>
Now the final table that I need to reach is a table that sum all costs for same employee across multiple sheets for a specific Code.
The Final Table of the example shown above would be like this:
<tbody>
</tbody>
I need to do this using formula and not filter. I would appreciate it someone can help with this!
I would appreciate it if someone can help me with this.
I have a workbook of 13 sheets. All 13 sheets contain the same information:Activity-Employee Code-Employee Name-Code1-Cost1-Code2-Cost2.
I'll show a small example to illustrate my case:
I have a table containing all Employees' Name and code
| Employee Name | Employee Code |
| Mark | 900 |
| Joe | 901 |
| Sally | 902 |
| Sam | 903 |
| Jesse | 904 |
| Ally | 905 |
| D.O | 800 |
| Liam | 801 |
| Al | 802 |
<tbody>
</tbody>
This Table is in Sheet1 of the same workbook.
Now Sheet2 Contains the following:
| Activity | Employee Code | Employee Name | Code1 | Cost1 | Code2 | Codet2 |
| A | Mark | 900 | 1020 | $ 10 | 1020 | $ 15 |
| A-105 | Joe | 901 | 1010 | $ 20 | 1010 | $ 18 |
| A-S05 | Al | 802 | 1020 | $ 15 | 1010 | $ 20 |
| B-106 | D.O | 800 | 1040 | $ 18 | 1020 | $ 15 |
| B-S06 | Jesse | 94 | 1020 | $ 20 | 1040 | $ 20 |
<tbody>
</tbody>
What I need to happen in this sheet is to extract all codes with the corresponding Employee Name and cost.
Let's Take for example Code 1020:
I need to have the following:
| Employee Name | Cost1 |
| Mark | $ 10 |
| Al | $ 15 |
| Jesse | $ 20 |
<tbody>
</tbody>
| Employee Name | Cost2 |
| Mark | $ 15 |
| D.O | $ 15 |
<tbody>
</tbody>
And then Having the Total Summary Table for both Cost (Cost1+Cost2)
| Employee Name | Total Cost |
| Mark | $ 25 |
| Al | $ 15 |
| Jesse | $ 20 |
| D.O | $ 15 |
<tbody>
</tbody>
By this the data for Sheet2 will be done.
Now if I jump to Sheet3 and do the same procedure, I'll end up with this total summary table :
| Employee Name | Total Cost |
| Sally | $ 35 |
| Sam | $ 10 |
| Mark | $ 17 |
| Jesse | $ 20 |
<tbody>
</tbody>
Now the final table that I need to reach is a table that sum all costs for same employee across multiple sheets for a specific Code.
The Final Table of the example shown above would be like this:
| Code | 1020 |
| Employee Name | Cost |
| Mark | $ 42 |
| Sally | $ 35 |
| Sam | $ 10 |
| Jesse | $ 40 |
| D.O | $ 15 |
| Al | $ 20 |
<tbody>
</tbody>
I need to do this using formula and not filter. I would appreciate it someone can help with this!
