Results 1 to 2 of 2

Group Picker Improvement (fix) needed

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2011
    Location
    Hamilton New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Group Picker Improvement (fix) needed

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1