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

Kemahiran: Pemprosesan Data, Excel, VB.NET, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: 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

Tentang Majikan:
( 13 ulasan ) Lakewood Ranch, United States

ID Projek: #17106693

Dianugerahkan kepada:


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 dalam 2 hari
(261 Ulasan)

11 pekerja bebas membida secara purata $50 untuk pekerjaan ini


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 Lagi

$100 USD dalam sehari
(290 Ulasan)

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 Lagi

$25 USD dalam sehari
(246 Ulasan)

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 Lagi

$88 USD dalam sehari
(174 Ulasan)

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 Lagi

$30 USD dalam sehari
(33 Ulasan)

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 Lagi

$150 USD dalam 2 hari
(3 Ulasan)

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 dalam sehari
(11 Ulasan)

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' Lagi

$25 USD dalam sehari
(4 Ulasan)
$35 USD dalam sehari
(7 Ulasan)
$10 USD dalam sehari
(0 Ulasan)

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 Lagi

$15 USD dalam sehari
(0 Ulasan)