Auto Allocate Pallet Numbers

Hi All,

I have a problem and not sure if it can be done.

Basically I have unique order numbers and part numbers. I am trying to automatically allocate a pallet number against each part number.

If the part number quantity is <=4 then it should be on the same pallet number for the same order, otherwise a new pallet number must be issued.

When a new order number starts, the process continues, anything <=4 is on one pallet number and anything else a new number should be issued. However, the first lot of allocated numbers must also be considered (i.e the pallet numbers always increase)

I have attached a spreadsheet highlighting how the pallet numbers would be allocated.

Thanks in advance

INFORMATION!!!
There seems to be a problem when I try to edit my previous post .
I get a notice:- "Website Unavailable"
What could it be ???
regards Mick