I have two worksheets
Worksheet "ORDER"
<tbody>
</tbody>
Worksheet "PRODUCTION"
<tbody>
</tbody>
I want to sum in "Order" column above from data to be consider from worksheet "ORDER"
for e.g. C2 should reflect result "4" taking into consideration data from worksheet Order (where Order 1 = 2 and Order 4 = 2)
Please help....I am stuck here badly
Regards!!!
Sandeep
Worksheet "ORDER"
A | B | C | D | E | |
1 | Part Name | Order 1 | Order 2 | Order 3 | Order 4 |
2 | Nut Bolts | 1 | 1 | ||
3 | Pistons | 2 | 2 | ||
4 | Hammers | 1 | 2 |
<tbody>
</tbody>
Worksheet "PRODUCTION"
A | B | C | D | |
1 | Part Name | Stock | Order | To be produced |
2 | Pistons | 1 | ||
3 | Hammers | 2 | ||
4 | Nut Bolts | 1 |
<tbody>
</tbody>
I want to sum in "Order" column above from data to be consider from worksheet "ORDER"
for e.g. C2 should reflect result "4" taking into consideration data from worksheet Order (where Order 1 = 2 and Order 4 = 2)
Please help....I am stuck here badly
Regards!!!
Sandeep