[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 41
  • Last Modified:

Team Rotation

Good Day All Experts,

I am trying to rotate partners from the list, I found few solutions from this site, which I already applied in attached sheet.

The rule is who is already have fixed partner, must not be used for rotation. For example, Andre Barnard teaming with Jaco De Jager always. These two must not be part of other member's rotation.

Please guide.
Team-Rotaion.xlsx
0
Shums
Asked:
Shums
  • 5
  • 4
2 Solutions
 
Martin LissRetired ProgrammerCommented:
Try this workbook.

By the way, in column "F" you have Partners spelled wrong.
28982747.xlsm
0
 
ShumsAsst. Financial ControllerAuthor Commented:
Thanks Martin,

Attachment doesn't have complete VBA.

Column F is automated with formula linked with Column A & B.

I want the result in Column F as I change the team number.
0
 
Martin LissRetired ProgrammerCommented:
There was a bug in that code. If this doesn't work then, if you can, please post your actual workbook.
28982747a.xlsm
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
ShumsAsst. Financial ControllerAuthor Commented:
Hi Martin,

Its still the same.

Please find original sheet again.
Team-Rotaion.xlsx
0
 
Martin LissRetired ProgrammerCommented:
Above you said
Attachment doesn't have complete VBA.
but you posted an xlsx workbook which removed any code that you had in it.
0
 
Martin LissRetired ProgrammerCommented:
BTW, I've created another version where a data validation list appears in column B that includes only the names of people who are not already paired with someone. Here's the "before" picture
BeforeAnd here is what I see after I select Andre Nolte.
AfterWhat more, if anything, should happen?
0
 
ShumsAsst. Financial ControllerAuthor Commented:
Martin that was good,

Your solution works very well where user will manually type the members in column B.

But I would like to automate this process, as I will change the Team from 2 to 3 in J1, Partners from F5 till last row must rotate the pair except those who already have paired.
0
 
Martin LissRetired ProgrammerCommented:
In the attached is my solution that I showed in my previous post. I believe that it does what you originally asked for and so if you agree I'd appreciate you closing this question and asking a new one for the rest.
28982747b.xlsm
0
 
ShumsAsst. Financial ControllerAuthor Commented:
there was no other option to accept.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now