Hello,
On sheet! 1 I have a macro to Create Teams. It is supposed to fill in the number of teams (Team A thru ....) by cell D35 and put names and ER numbers from column A.
It does randomly assign names and ER numbers but there are blank cells and not all ER numbers are filling in.
Can someone please take a look?
Thank you very much,
XJ
Looks like your problem is in the Shuffle Players - The randomizing will not create unique assignments and when the duplicate assignments are made, you lose the initial one
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you for the reply. Can it be fixed?
Devise a way to choose each player once.
Logical thanks. I appreciate that you at least are pointing me in the right direction.
You're welcome and thanks for the rep!
Sure you have always helped and deserve the credit.
I am trying to figure out how to randomly select the players without the blanks but no success yet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks