Random Sequencing

[victor222]

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

 

[HackSlash]

What are your data inputs and what are your data outputs?

Do you have a spreadsheet? Do you have some code?