Good Morning everybody, this is my first post in this forum, hope I'll be able to express myself properly.
I'm trying to make a excel sheet with following features:
There are lets say 3 groups, each group having particular Items with different quantities (there can be common items) see the following:-
<tbody>
</tbody>
Now there are different products using these groups with different quantities, lets say:-
<tbody>
</tbody>
Now I want a common list to be generated of "Items" used & their quantities.
<colgroup><col width="96" span="2" style="width:72pt"> </colgroup><tbody>
</tbody>
Please help me out. Thanks.
with best regards.
I'm trying to make a excel sheet with following features:
There are lets say 3 groups, each group having particular Items with different quantities (there can be common items) see the following:-
Item1 | 1 | |||
Group1 | Item2 | 5 | ||
Item3 | 8 | |||
Item4 | 2 | |||
Group2 | Item2 | 1 | ||
Item3 | 4 | |||
Item7 | 7 | |||
Item5 | 6 | |||
Item6 | 1 | |||
Item1 | 4 | |||
Group3 | Item5 | 10 | ||
Item3 | 7 | |||
<tbody>
</tbody>
Now there are different products using these groups with different quantities, lets say:-
Group1 * 2 | |
Product 1 | Group2 * 3 |
Group3 * 1 | |
Product 2 | Group2 * 7 |
Group3 * 5 | |
Group1 * 5 | |
Product 3 | Group3 * 2 |
<tbody>
</tbody>
Now I want a common list to be generated of "Items" used & their quantities.
Quantities | |
Item1 | |
Item2 | |
Item3 | |
Item4 | |
Item5 | |
Item6 | |
Item7 |
<colgroup><col width="96" span="2" style="width:72pt"> </colgroup><tbody>
</tbody>
Please help me out. Thanks.
with best regards.
Last edited: