Hello all,
I found this Team Generator and I need to increase the number of officers.
At present it generates 4 teams, each team has 1 leader, 1 assistant and 2 officers.
Can you help me to add more officers, let's say 8...9 or 10 officers/team, please?
and
is possible to have variant 2 with desired leaders and assistants and the officers randomly only?
Thank you very much for your help!
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Hello,
can anyone help me, please?
There are no macros in the attachment, so there us nothing to help you to adapt.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi Ali,
yes, there is..
Please Login or Register to view this content.
Hey John,
Attach a sample of what you have or what it should look like. The example from 2010 that you attaches is a little scattered.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi Marvin
Thanks!
What I want is to have 4 teams. Each team has to have a leader, an assistant and officers.
in my example, I have 4 leaders, 4 assistants and 37 officers (or more, or less).
-one way is to establish myself the leaders and assistants and arrange the officers randomly
-another way is to arrange randomly all of them.
Attached a test file for your reference!
Hi John,
The better method for sorting people randomly is to use a Rand() column and then sort the people. Because the last column has the most people I used it to show you how to do this. See the attached. I think this method is much better instead of VBA. You can use this method for lots of different kinds of problems. If you need it to look exactly like you have in your attached, you could copy from the Pivot and past values using transpose.
Random Column to pick teams.xls
a little bit complicated but it's ok!
Thanks a lot!
Hi all,
Is any vba solution for this?
thank you very much for your help!
Hi John,
maybe something like this (with using ShuffleArray function)
Please Login or Register to view this content.
Hi Nilem,
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks