Hi, I am looking for a VBA code to generate group of combinations from 11 of 22 elements which satisfy multiple condition.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 295"]
[TD="class: xl63, width: 145"]Group[/TD]
[TD="class: xl63, width: 94"]Group-Task[/TD]
[TD="class: xl64, width: 62"]Name[/TD]
[TD="class: xl63, width: 38"]Value[/TD]
[TD="class: xl63, width: 52"]Capacity[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Base[/TD]
[TD="class: xl67"]A[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]50.73[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Audio[/TD]
[TD="class: xl67"]B[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]75.14[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Base[/TD]
[TD="class: xl67"]C[/TD]
[TD="class: xl66"]10[/TD]
[TD="class: xl66"]73.78[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Base[/TD]
[TD="class: xl67"]D[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]55.4[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Volume[/TD]
[TD="class: xl67"]E[/TD]
[TD="class: xl66"]8.5[/TD]
[TD="class: xl66"]35.61[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Audio[/TD]
[TD="class: xl67"]F[/TD]
[TD="class: xl66"]8.5[/TD]
[TD="class: xl66"]34.7[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Volume[/TD]
[TD="class: xl67"]G[/TD]
[TD="class: xl66"]8.5[/TD]
[TD="class: xl66"]18.3[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Volume[/TD]
[TD="class: xl67"]H[/TD]
[TD="class: xl66"]8.5[/TD]
[TD="class: xl66"]26.37[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Audio[/TD]
[TD="class: xl67"]I[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]59.62[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Volume[/TD]
[TD="class: xl67"]J[/TD]
[TD="class: xl66"]8.5[/TD]
[TD="class: xl66"]23.99[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Base[/TD]
[TD="class: xl67"]K[/TD]
[TD="class: xl66"]8[/TD]
[TD="class: xl66"]5.88[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Base[/TD]
[TD="class: xl67"]L[/TD]
[TD="class: xl66"]8[/TD]
[TD="class: xl66"]8.84[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Base[/TD]
[TD="class: xl67"]M[/TD]
[TD="class: xl66"]8[/TD]
[TD="class: xl66"]8.33[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Base[/TD]
[TD="class: xl67"]N[/TD]
[TD="class: xl66"]8.5[/TD]
[TD="class: xl66"]44[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Audio[/TD]
[TD="class: xl67"]O[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]71.99[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Volume[/TD]
[TD="class: xl67"]P[/TD]
[TD="class: xl66"]10[/TD]
[TD="class: xl66"]70.74[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Volume[/TD]
[TD="class: xl67"]Q[/TD]
[TD="class: xl66"]10.5[/TD]
[TD="class: xl66"]47.66[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Volume[/TD]
[TD="class: xl67"]R[/TD]
[TD="class: xl66"]8[/TD]
[TD="class: xl66"]10.06[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Audio[/TD]
[TD="class: xl67"]S[/TD]
[TD="class: xl66"]8.5[/TD]
[TD="class: xl66"]64.96[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Volume[/TD]
[TD="class: xl67"]T[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]63.29[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]Group1-Singer[/TD]
[TD="class: xl67"]U[/TD]
[TD="class: xl66"]8.5[/TD]
[TD="class: xl66"]51.2[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]Group2-Singer[/TD]
[TD="class: xl67"]V[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]58.35[/TD]
[/TABLE]
My criteria:
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 227"]
[TD="class: xl67, width: 145"]Criteria[/TD]
[TD="class: xl67, width: 94"]Minimum[/TD]
[TD="class: xl68, width: 62"]Maximum[/TD]
[TD="class: xl66"]Group1[/TD]
[TD="class: xl66"]4[/TD]
[TD="class: xl66"]7[/TD]
[TD="class: xl66"]Group2[/TD]
[TD="class: xl66"]7[/TD]
[TD="class: xl66"]4[/TD]
[TD="class: xl66"]Singer[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]Base[/TD]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]5[/TD]
[TD="class: xl66"]Audio[/TD]
[TD="class: xl66"]1[/TD]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]Volume[/TD]
[TD="class: xl66"]3[/TD]
[TD="class: xl66"]5[/TD]
[TD="class: xl66"]Combination Total Value[/TD]
[TD="class: xl66"]100[/TD]
[TD="class: xl66"] [/TD]
[/TABLE]
Also, need to publish the results with all the give data. Thanks for your help in advance.