I have a file that gives me forcasted stock position per month. This is based on a lead time vs my forecast
So for example a supplier has a lead time of 4 months, so i need to know if in the next 4 months if i will go into a negative stock position. After that it does not matter as the sytem will generte an order.
This would be easy but differant suppliers have differant lead times, so i would like to create a macro that highlights a negative cell based on a lead time. I have the lead time in a cell and have coverted this into a month value . I can then put this into my day end so when the planners arrive they can focus on the parts that will run out rather than all parts from a supplier.