You're beginning to appreciate how you have to think of everything when coding; just when you think you've got the algorithm right it throws another gotcha at you!Another issue I found with the code is the Row Number changes when one of the loops is executed.
I've been doing some background reading about sugarcane production! Interesting stuff.
To understand the context of this thread, am I right in thinking the Daily Quota sheet is harvest tonnage from the fields on those dates?
And that that harvest has to be taken to the mill that day (or asap)?
Are you at the mill, a producer of raw cane, both? Where do you stand in the whole process?
What is the processing each row represents?
On the Sort Formula sheet what do the Names represent? Are they perhaps fields? Perhaps they're company orders?
Anything you can add (because it brings to life the problem I'm helping to solve) would be great.
What country is all this happening in?
I see there are a few rows with long periods between Grow Start and Not Before date, some approaching 2 years: CW, CX, CZ, CY. Are these correct?
I'll look at his again tomorrow, it's late evening here.