Today I have the following problem to solve:
Code: Select all
Date: wk1 wk2 wk3 wk4 wk5
Donuts: 50 30 15 -5 -20
I want to record when I run out of donuts on another worksheet, in this case wk4
I have lots of other items, not just donuts, so I need to lookup donuts, and report the week stocks go negative on the other sheet.
Hope that makes sense?
If anyone can help I would be most apreciative!