cominations vba

[Rajeev Muraleedharan]

i need vba codes for the below project. i have a list of 22 players from 2 teams like

Name of Player	Team	Position	Credits
Bryan	Team1	Bat	9.5​
Daniel	Team2	Bowl	8​
Paul	Team2	All	8.5​
Wright	Team2	Bat	10.5​
Sam	Team1	Bat	11​
Suni	Team1	Bowl	9​
Sachin	Team1	All	8​

etc...

i need all possible combination of 11 members from this 22 members according to the below conditions.

the conditions are:
1. There should be minimum 4 players and Maximum of 7 players from each team.
2. WK - minimum 1 and max 4 members
3. BAT - minimum 3 and max 6 members
4. ALL - minimum1 and max 4 members
5. BOWL - minimum 3 and max 6 members
6. Only need those teams whose sum total is less than or equal to 100 credits.
7. there should not be any repetitions like sachin, suni again repeated as suni sachin.

The result should be generated in the next sheet in columns as 11 member team like
Bryan
Suni
Sachin
kannan
daniel etc

Can anyone help on this?

 

[StephenCrump]

Duplicate, already answered here: Need Vba codes for the following

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).