Fruit Company Ordering Schedule

[rjerand]

I have a fruit company that I either send out shipments in the AM or PM on a given day during a 2-week pay period.

The AM and PM are separated on Sheet 1 along with the shipment day for each fruit. If an "X" is in the box, then that means it's shipment day for that fruit. AM fruit will never be shipped on PM and PM fruit will never be shipped on AM, so it's more of a clear cut schedule and no AM/PM crossover.

On Sheet 2 - The fruit (of course still separated by AM and PM) are listed in order they appear on sheet 1. Of course if an "X" is listed in their box for that given day (on sheet 1) they will appear in order on sheet 2. I have manually put them in, but how do I function it so it auto populates? Especially if I have to change the shipping day on sheet 1.

Any help would be great. I have attached the document.

[Bernie Deitrick]

Try the attached - the formulas are array formulas, requiring Ctrl-Shift-Enter instead of just Enter.