I need to come up with all the combinations for the below data. I have numbers, colors and names. I need to put one number, two colors and three names in a row without repeating a name or color in each row. I would also like to not replicate the rows with the colors or names in a different order. The top row on my output sheet would have the headers as seen below and then I have a data tab which lists the possible inputs. It would be great to also know how to limit the value of the entire row to say 10 if each input had a value of 1-5. If that is not possible, I can delete the rows with values greater than 10. I would like to do all this within VBA code.
<tbody>
</tbody>
<tbody>
</tbody>
Number | Color | Color | Name | Name | Name |
<tbody>
</tbody>
Number | 1 |
Number | 2 |
Number | 3 |
Number | 4 |
Number | 5 |
Number | 6 |
Number | 7 |
Number | 8 |
Number | 9 |
Number | 10 |
Color | Black |
Color | Blue |
Color | Yellow |
Color | Orange |
Color | Red |
Color | Green |
Color | Plum |
Color | Purple |
Color | Pink |
Color | Gray |
Color | White |
Name | Adam |
Name | Joe |
Name | Brett |
Name | Aaron |
Name | Jerry |
Name | Kim |
Name | James |
Name | Pat |
Name | Jeff |
Name | Rob |
Name | Bill |
<tbody>
</tbody>