trying to write a vba code to loop a goal seek to calculate the required materials

Copper Contributor

I am using goal seek to calculate the material required to keep days of stock at 30. for example:  if the "Days of Stock" is < 30 then the "requirement" in June should generate the material required to keep it at 30. but if days of stock is already at 30 or more then it should skip over. 

Attached is the code i have so far and a sample of the file I am working on

0 Replies