This inventory list is for when employees are given work material. It uses vlookup for item numbers (some doesn't have any) and vlookup for the shift the employee works on to pull up data. It will be maintained by a customer service rep without any excel experience, just data entry.
What I would like is an easy way to:
Calculate remaining qty. Currently, you have to remember/find what was remaining amount so that a basic subtraction equation to take effect.
A reorder point notifier.
I can explain to the CSR how to maintain. It's just that everything I'm finding on youtube seems to be so overpowered for what I'm trying to make happen.
Please take a look
What I would like is an easy way to:
Calculate remaining qty. Currently, you have to remember/find what was remaining amount so that a basic subtraction equation to take effect.
A reorder point notifier.
I can explain to the CSR how to maintain. It's just that everything I'm finding on youtube seems to be so overpowered for what I'm trying to make happen.
Please take a look