I have a workbook with a Summary page and 5 employee pages:
Tabs are: Summary, Name1, Name2...Name5
On the summary page I have columns: Job (which is our job number), Panel (number of hours), Wire (number of hours) ... and others, all numbers of hours.
On each of the employee pages I have columns: Job (which is our job number), Panel (number of hours), Wire (number of hours) ... and others, all numbers of hours.
What I'm trying to do is for a given job, sum all the hours for each operation (Panel, wire, etc) and put the total in the summary page.
So on the summary page, lets say I have the following data:
Summary Page
<tbody>
</tbody>
On two employee pages I have:
Name1 Page
<tbody>
</tbody>
Name2 Page
<tbody>
</tbody>
I want the summary page to show:
Summary Page
<tbody>
</tbody>
Can somebody help me to figure out how to do this? Any and all help is appreciated. Thank you.
Tabs are: Summary, Name1, Name2...Name5
On the summary page I have columns: Job (which is our job number), Panel (number of hours), Wire (number of hours) ... and others, all numbers of hours.
On each of the employee pages I have columns: Job (which is our job number), Panel (number of hours), Wire (number of hours) ... and others, all numbers of hours.
What I'm trying to do is for a given job, sum all the hours for each operation (Panel, wire, etc) and put the total in the summary page.
So on the summary page, lets say I have the following data:
Summary Page
Job | Panel | Wire |
1 | ||
2 |
<tbody>
</tbody>
On two employee pages I have:
Name1 Page
Job | Panel | Wire |
1 | 5 | 7 |
4 | 10 |
<tbody>
</tbody>
Name2 Page
Job | Panel | Wire |
1 | 4 | |
2 | 6 | 8 |
<tbody>
</tbody>
I want the summary page to show:
Summary Page
Job | Panel | Wire |
1 | 9 | 7 |
2 | 6 | 8 |
4 | 10 |
<tbody>
</tbody>
Can somebody help me to figure out how to do this? Any and all help is appreciated. Thank you.