Excel_Blonde
New Member
- Joined
- Aug 8, 2018
- Messages
- 44
Hi There,
Another day, another challenge!
I'm working on a stock shortages report and cant figure out how to lookup the stock value in another sheet and then cumulative subtract as it moves down the list.
E.g
Stock levels (Sheet3)
<tbody>
</tbody>
Active Sheet (Sheet2)
<tbody>
</tbody>
I'm not sure whether I need to have a cumulative shortage or shortage by order so both solutions would be helpful.
Any help would be appreciated.
Another day, another challenge!
I'm working on a stock shortages report and cant figure out how to lookup the stock value in another sheet and then cumulative subtract as it moves down the list.
E.g
Stock levels (Sheet3)
Column | Part | Qty |
A | Apple | 12 |
B | Banana | 6 |
C | Carrot | 18 |
D | Cake | 0 |
E | Biscuit | 7 |
<tbody>
</tbody>
Active Sheet (Sheet2)
Column | Order | Part | Qty | Shortages |
A | 1 | Banana | 6 | 0 |
B | 2 | Apple | 3 | 0 |
C | 3 | Apple | 6 | 0 |
D | 4 | Banana | 3 | 3 |
E | 5 | Apple | 5 | 2 |
F | 6 | Cake | 2 | 2 |
G | 7 | Apple | 8 | 8 |
<tbody>
</tbody>
I'm not sure whether I need to have a cumulative shortage or shortage by order so both solutions would be helpful.
Any help would be appreciated.