VBA to randomly select from list with criteria

[derek_e2015]

Hello,
I am trying to randomly select from a list (say 4 items in the list) and input the values into say 16 cells, But each item in the list can only be used a set number of times
Also thinking may have to do something where i have the full list of all item on the list, each item listed the number of times they need to appear then input them into the 16 cells and shuffle them but have not looked into that yet
Example:

Bob - needs to appear 5 time
Lisa - needs to appear 3 times
Steve - needs to appear 2 times
Sue - needs to apear 6 times

So the chart would look like this

bob - steve - bob - lisa
sue - lisa - sue - Bob
Steve - bob - bob - sue
Sue - Sue - lisa - sue

I can create a macro to randomly select from the list with a formula but can not figure out how to get the items in the list to only appear a set number of times.
any assistance on this would be greatly appreciated very new to VBA/Macros and I am unable to find any thing out there like this

Thank you

 

[derek_e2015]

Sorry forgot to mention my actual list has 13 values and needs to input into about 100 cells, so I am trying to create a macro so I can add a Form control button to run the macro when ever I need to Can get the random part and the button, which is pretty easy but just cannot figure out how to get the item in the list to only appear a set number of times

Thank you