Excel VB/Macro creation - Random team selection based on multiple criteria

I help run a pick up soccer league in my hometown and we are always arguing about unfair/unbalanced teams so I am praying someone on here can help me come up with a macro to solve this. I have created the attached spreadsheet

What I am hoping is the following can be achieved:

1. A button can be pressed to randomly generate teams in Team 1, 2, 3 and 4 (depending on how many total players)

2. Teams should include a minimum of 4 defenders, 3 midfielders and 3 attackers (rest random)

3. Each Team should not exceed "Max Number of Players Per Team"

4. Team score should be an average of Player ratings for each team

5. Team Score should be as close as possible for each team

6. Only players with x in "Present" to be included in the Teams

7. Each time the button is pressed in step 1 the teams will regenerate

Skills: Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps

See more: excel random selection from range, excel random sample multiple columns, excel random generator from list, excel random select from list based on another cell, excel random select if, excel randomly select cells based on criteria, excel random selection from list without repetition, excel random selection with criteria, macro creation excel, vb sum based multiple criteria, vb macro convert word excel, vb excel unicode macro, excel vb web page macro, excel vb macro, excel project macro samples, excel permutation macro, data excel sheet macro, excel unicode macro, excel vba macro paste adjacent column, excel comparing macro code

About the Employer:
( 13 reviews ) Lakewood Ranch, United States

Project ID: #17106693

Awarded to:


Hi, the project is well described. All is clear. I can code the macro to generate the 4 teams with respect of all the constraintes you mentionned. Thanks

$60 USD in 2 days
(261 Reviews)

11 freelancers are bidding on average $50 for this job


Hello, I can help with you in your project Excel VB/Macro creation. I have more than 5 years of experience in Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps. We have worked on several similar pr More

$100 USD in 1 day
(290 Reviews)

HI, Couple of variables I have in mind to distribute players to team evenly. Half of the work already done by you for SKill/Age score. Distribution can be done this way. Based on all players skill, the minimum More

$25 USD in 1 day
(246 Reviews)

Hello there, I can try. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline More

$88 USD in 1 day
(174 Reviews)

Hi, You won’t select the right candidate without knowing what your project on building a macro to create random teams will look like. Fortunately, I can complete a part of your job before you award the project. I More

$30 USD in 1 day
(33 Reviews)

Hi, I have Read Your Project Excel work . I am very Interested in your Project and also I am ready to Start Immediately. I assure you will like my Work very much and i will give you unlimited changes and I will delive More

$150 USD in 2 days
(3 Reviews)

Hello, I can help you in this Project. I have an idea a how the excel will work to randomize teams. I'd Like to continue talking about this Project so please Contact me. Thank you very much for your time.

$15 USD in 1 day
(11 Reviews)

Dear Client, I am a professional data processing expert, with over 1 years experience dealing with Microsoft office, web upload, data collected. I am ready to start your project right now & ready to do an example. I' More

$25 USD in 1 day
(4 Reviews)
$35 USD in 1 day
(7 Reviews)
$10 USD in 1 day
(0 Reviews)

Hi team, I would love to take the opportunity to work as a freelancer. I am currently working as Finance analyst for big Pharmaceutical company (PPD), where I work with tons of data in excel. However I am now on mater More

$15 USD in 1 day
(0 Reviews)