Hi all, I am trying to find the best way to fill up a dynamic table with the right values as easily as possible (hopefully one click) once I input the the order number and it's details.
I am stumped not sure whether I'll need to use helper columns / vba.
I wanted to get the answers to the "To Pack From Inventory" and "To Wait For Stock To Arrive" column.
<tbody>
</tbody>
Current Inventory:
<tbody>
</tbody>
The answer needed:
<tbody>
</tbody>
What would be the most efficient and easiest way to achieve this? Thank you all in advanced for any thoughts on this!
I am stumped not sure whether I'll need to use helper columns / vba.
I wanted to get the answers to the "To Pack From Inventory" and "To Wait For Stock To Arrive" column.
Order Number | Fruit Ordered | Quantity Ordered | To Pack from Current Inventory | Wait for Stock to Arrive |
1001 | Apples | 7 | ||
1001 | Oranges | 7 | ||
1001 | Kiwi | 5 | ||
1005 | Apples | 5 | ||
1005 | Oranges | 5 | ||
1008 | Apples | 3 |
<tbody>
</tbody>
Current Inventory:
Fruit | Current Inventory |
Apples | 10 |
Oranges | 5 |
Kiwi | 5 |
<tbody>
</tbody>
The answer needed:
Order Number | Fruit Ordered | Quantity Ordered | To Pack from Inventory | Wait for Stock to Arrive |
1001 | Apples | 7 | 7 | 0 |
1001 | Oranges | 7 | 5 | 2 |
1001 | Kiwi | 5 | 5 | 0 |
1005 | Apples | 5 | 3 | 2 |
1005 | Oranges | 5 | 0 | 5 |
1008 | Apples | 3 | 0 | 3 |
<tbody>
</tbody>
What would be the most efficient and easiest way to achieve this? Thank you all in advanced for any thoughts on this!