rodoconnor3
New Member
- Joined
- Jan 30, 2020
- Messages
- 1
- Office Version
- 2007
- Platform
- Windows
Hello,
Im using excel to track our historic sales and forecasted sales. I have limits for min and max stocks of Product A. What I would like to do is have the excel sheet identify when stocks are forecast to go below min, generate the need for a re-order at that point in the future and then amend the stock forecast to reflect the arrival of the new stock.
Im getting caught in an itteration loop. Any help is appreciated.
Thanks,
Rodger
Im using excel to track our historic sales and forecasted sales. I have limits for min and max stocks of Product A. What I would like to do is have the excel sheet identify when stocks are forecast to go below min, generate the need for a re-order at that point in the future and then amend the stock forecast to reflect the arrival of the new stock.
Im getting caught in an itteration loop. Any help is appreciated.
Thanks,
Rodger