Dynamic Calendar that predicts when something will need to be ordered again

Thank you very much for following up with this! I apologize for the delay and with being vague with some of the functions I'm trying to accomplish.

The "Predictor for the future" sheet contains the cycle times which is fixed for each of the products and I already have all of the products manually input so I was thinking it might be easier to leave those manually input on the "Predictor for future" sheet so that the cycle days column wouldn't be a problem?

I was trying to mess with the code underneath the calendar so that if it was before the last time purchased in column C then it would grab the hours from the "Input Data" sheet with respect to the dates in the calendar and the ones input in column E of the "Input Data" sheet because the dates are kept from the past to see trends and if anything was missed. And if the corresponding date in the calendar matched with the last time purchased in column C of the "Predictor for the future" sheet then it would upload the hours for that date and upload the future date with regards to the cycle. I also was trying to find a way to document whether hours were missed in a cycle because sometimes an item isn't ordered and when the item pops up again due to it's cycle it is left blank when updated on the "Input Data" sheet.

I tried approaching it the way bebo did in https://www.excelforum.com/excel-for...ml#post5453755 by scanning the other sheet to update on the predictor for future sheet but I think I'm missing something by multiplying the ranges and I'm not too sure how that works.



Thank you for your patience and persistence with helping me!

Is this a duplicate thread of another one by you which has "Dynamic Calendar" in the title?

Pete

After adjusting a couple things with the foundation you guys laid I was able to get it to work. Thank you for all the help and with sharing new methods of approach to the excel function!