Formula/VBA to calculate sum in adjacent cells with conditions & transfer to last cell

[kaav06]

Hi,

I have data in the sample format below. There are many thousands of rows of data. I have min and max prod date. Column values represent number of pallets. I am not sure how to explain what I need to do. I have given expected outcome to make it easier to understand.

Any full pallets (full pallets refers to whole numbers) stay in the same cell and any part pallets (decimals) needs to be carried over until a next full pallet can be formed. If a full pallet cannot be formed in between min and max prod date, any/all partial pallets need to be transferred to the date after max prod date.

I was thinking to use mod and quotient but I am stuck as to how to do it as a process in finding next partial or full pallet and keep running until the date after max date.


Thanks

[JeteMc]

All of the values in the file seem to be text (can be determined because they slide to the left when alignment formatting is removed) with the exception of cells K5 and K11.
Please upload another file in which dates are actual dates and values in tables are numbers.
Let us know if you have any questions.