Thank you, Luke. I didn't think I had posted this question, so forgive my repeat. Your scenario is close, but not quite what I need. I cannot upload an example. Can I email a sample worksheet to you directly? Thank you for your help.
This is my first time to post a question, so please forgive me if my question is unclear.
Currently, I print PDF reports sent to me each morning from the AS400. The report shows the planned daily average quantity (per day) and the actual daily average. Each morning I print this report and...
Each day I get a report with several products listed with their daily plan and listed below each day in the period -- as it occurs. In other words, on the second day of the production period there is one entry for day one, on the third day there are two entries, etc. up to the end of the period...