Hello,
I have received help with this file which has been instrumental. If you look at Sheet 1 I have an area where items are listed if they are before the current date, meaning they are late. Here is my question. In the data sheet I would like all the late items to populate in rows 6-37 before the regual data for that date. In other words it is making late items the first scheduled priority for that day and then regularly schedule items would fill the remaining capacity. I have tried to make variations of the current formula but cannot figure out how to make the items before current date populate first. Any ideas?
Bookmarks