Before withdraw on inventory monitoring page:
<tbody>
</tbody>
Withdrawing on inventory withdrawal page(different tab):
<tbody>
</tbody>
What formula should use for cell E2 to E4?
After withdraw on inventory monitoring page:
<tbody>
</tbody>
What formula should use for cell D2 to D5?
I already crack my head how to link and share the in stock balance as above different tab shown.
Please help and educate me.
Thanks.
A | B | C | D |
1 | Part Number | Start Stock Qty | In Stock Balance |
2 | 123 | 10 | 8 |
3 | 456 | 20 | 7 |
4 | 789 | 30 | 6 |
5 | 101 | 40 | 5 |
<tbody>
</tbody>
Withdrawing on inventory withdrawal page(different tab):
A | B | C | D | E |
1 | Date Withdraw | Part Number | Withdraw Qty | In Stock Balance |
2 | 05 Sep | 123 | 2 | 6 |
3 | 06 Sep | 456 | 3 | 4 |
4 | 07 Sep | 123 | 1 | 5 |
<tbody>
</tbody>
What formula should use for cell E2 to E4?
After withdraw on inventory monitoring page:
A | B | C | D |
1 | Part Number | Start Stock Qty | In Stock Qty |
2 | 123 | 10 | 5 |
3 | 456 | 20 | 4 |
4 | 789 | 30 | 6 |
5 | 101 | 40 | 5 |
<tbody>
</tbody>
What formula should use for cell D2 to D5?
I already crack my head how to link and share the in stock balance as above different tab shown.
Please help and educate me.
Thanks.