JPCoelho29
New Member
- Joined
- Feb 13, 2015
- Messages
- 3
Hi, I'm not an excel expert and I need some guidance.
I need to create a table where I can see the the quantity of material requirements for the ordered quantity of products. I have two tables like these:
Orders Table
<tbody>
</tbody>
Bill of Materials Table
<tbody>
</tbody>
And the table that I want to get is something like this:
<tbody>
</tbody>
Someone knows how can I achieve this result? Thanks in advance!
I need to create a table where I can see the the quantity of material requirements for the ordered quantity of products. I have two tables like these:
Orders Table
Order number | Product Code | Ordered Quantity |
52098 | 2147561 | 15000 |
52098 | 3387595 | 5000 |
<tbody>
</tbody>
Bill of Materials Table
Product Code | SubProduct Code | SubProQuantity/Product |
2147561 | 80603 | 0,5 |
2147561 | 23127 | 1 |
2147561 | 11002 | 1 |
3387595 | 80603 | 0,5 |
3387595 | 29034 | 1 |
3387595 | 11015 | 2 |
<tbody>
</tbody>
And the table that I want to get is something like this:
Order Number | Product Code | SubProduct Code | SubProduct Total Quantity |
52098 | 2147561 | 80603 | 7500 |
52098 | 2147561 | 23127 | 15000 |
52098 | 2147561 | 11002 | 15000 |
<tbody>
</tbody>
Someone knows how can I achieve this result? Thanks in advance!