Group Picker Improvement (fix) needed

[Jayveeare]

I am impressed with the Team picker spreadsheet and associated coding.
I have recently returned to teaching High School students and have a need to generate groups of 4 & 3 as well as 4 & 5. I have modified the Golf Teampicker spreadsheet to do the 4 and 5 groups, and this with the exception of one addition is working superbly.

My coding knowledge is poor in VB as I have not coded much since MSDos Basic days. I have managed to make changes to the original code but this is very shallow and cosmetic only and I can not get the code to populate the class list correctly. I have included some excel comments in key cells to explain the problem. At the moment I can get the code to make the correct number of rows but I can not get it to only fill the correct items per row. I have generated the number of foursomes and threesomes based on a matrix sheet.

Also an extra bonus would be to be able to select only those present to generate the groups from. I have put a tick control box in on sheet to show the chosen students to make the class list for inclusion into the groups.
Each Groupsheet would load the ID number's next to the ticked boxes only and then contiguously populate the first column with present students ID numbers.

[MarvinP]

Hi Jayveeare and welcome to the forum, and in creating your first new thread.

You need some help on this. The first topic is called Diophantine Equations. See:
http://www.wikihow.com/Solve-a-Linea...ntine-Equation
and then look at the attached spreadsheet to see how to calculate them instead of using the matrix table you built.

Secondly I've found check boxes much too hard to deal with. I've created a substitute where an x is put in a cell (your column A) using a double click instead of the check box. Find it also attached. With an "x" in the cells you can then count the number of x and it is easier than what you have.

It looks like you are having a problem in copying only the checked (x ed) students names to the second or third sheet. If I remember correctly, we did a table filter (called list) on the first sheet to only show the students with an x next to their names. Then we copied this list to the other sheets.

With an x instead of a check box you will be able to filter only those rows that have an x in them. With the Check Box you couldn't do that and makes sense that you got stuck.

Those Check Boxes look cool but are much harder to work with.

After putting in the x double click routine and removing those (hard to work with) check boxes, see if you can filter the students who have an X next to their names. Copy and paste that to your other sheets. DO THIS by hand a few times to see if it works. Then record a macro to do it. Then figure out what the macro is doing and fix it's code, if needed.

I think the above will get you working in the right direction. I was impressed with your "Intersect" line of code. That is pretty advanced for a noob in VBA programming.

Hope this helps. If not send me what you have updated.