Deansamson
New Member
- Joined
- Jul 2, 2020
- Messages
- 1
- Office Version
- 365
- 2019
- Platform
- MacOS
Hello everyone,
Thins is my first time posting so apologies if its in the incorrect place.
In our bakery we use a certain type of bakery manufacturing software which if I'm honest isn't great. Mention no names.
Anyway I'm having to create a system to compensate, I created a demand planner, which I input product quantities and using psims it works out how much of each ingredient is needs plus a cost etc.
I wanted to add a stock/location module to it. Basically I want to add raw materials to is and when I input products on my planner it will automatically deduct raw materials on the other sheet. That I have sorted BUT is there any way excel can use from one cell then whe that cell shows 0 it automatically goes the a chosen cell. Ie the next batch of raw materials.
Many thanks
Thins is my first time posting so apologies if its in the incorrect place.
In our bakery we use a certain type of bakery manufacturing software which if I'm honest isn't great. Mention no names.
Anyway I'm having to create a system to compensate, I created a demand planner, which I input product quantities and using psims it works out how much of each ingredient is needs plus a cost etc.
I wanted to add a stock/location module to it. Basically I want to add raw materials to is and when I input products on my planner it will automatically deduct raw materials on the other sheet. That I have sorted BUT is there any way excel can use from one cell then whe that cell shows 0 it automatically goes the a chosen cell. Ie the next batch of raw materials.
Many thanks