Hello all,

I am looking for help with this vba problem i have.

I have a system that accepts 3 types of demand in bulk. Each bulk has quantities in it. I have been able to split this quantities randomly from 1 to 5 splits before going into the system sequencially. But now i want these splits to go in a random sequence with no same type following each other.
For example

Type 1: 5 quantities; splitted into 2,3
Type 2: 7 quantities; splitted into 3,4
Type 3: 6 quantities; splitted into 1,1,1,1,2

And they go into the system in that sequence: 2,3,3,4,1,1,1,1,2

But i want to sequence to be random with no two of the same type following each other.

Please how can I achieve this with code.

Thanks