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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Order Number[/TD]
[TD]Fruit Ordered[/TD]
[TD]Quantity Ordered[/TD]
[TD]To Pack from Current Inventory[/TD]
[TD]Wait for Stock to Arrive[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Apples[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Oranges[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Kiwi[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]Apples[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]Oranges[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1008[/TD]
[TD]Apples[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Current Inventory:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Fruit[/TD]
[TD]Current Inventory[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Kiwi[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
The answer needed:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Order Number[/TD]
[TD]Fruit Ordered[/TD]
[TD]Quantity Ordered[/TD]
[TD]To Pack from Inventory[/TD]
[TD]Wait for Stock to Arrive[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Apples[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Oranges[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Kiwi[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]Apples[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]Oranges[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1008[/TD]
[TD]Apples[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Order Number[/TD]
[TD]Fruit Ordered[/TD]
[TD]Quantity Ordered[/TD]
[TD]To Pack from Current Inventory[/TD]
[TD]Wait for Stock to Arrive[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Apples[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Oranges[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Kiwi[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]Apples[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]Oranges[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1008[/TD]
[TD]Apples[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Current Inventory:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Fruit[/TD]
[TD]Current Inventory[/TD]
[/TR]
[TR]
[TD]Apples[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Kiwi[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
The answer needed:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Order Number[/TD]
[TD]Fruit Ordered[/TD]
[TD]Quantity Ordered[/TD]
[TD]To Pack from Inventory[/TD]
[TD]Wait for Stock to Arrive[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Apples[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Oranges[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1001[/TD]
[TD]Kiwi[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]Apples[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1005[/TD]
[TD]Oranges[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]1008[/TD]
[TD]Apples[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
What would be the most efficient and easiest way to achieve this? Thank you all in advanced for any thoughts on this!