Fantasy Baseball Transactions

Hi

I am trying to automate the transaction process for my fantasy baseball team. There are ten teams and they may acquire any number of free agent players in a given week in a priority order--they submit their preferences individually and so there may be overlap in players desired...and I would like to automate this so that a player is only assigned to one team in priority order.

So I envision a spreadsheet -- with the ten teams (in the priority order) listed vertically; and their player preferences listed horizontally

So Team 1 would acquire Player A; I would then want the spreadsheet to look thru the spreadsheet and eliminate Player A from any other team preferences for selection. Team 1 may also have contingent selection - that is if Team 1 acquires Player A, it eliminates their desire to acquire Player B (i.e., it wants one or the other - but not both) and so I would want the spreadsheet to look right for Team A and eliminate Player B from potential selection in subsequent rounds

The spreadsheet would then go to Team 2 - and select the first available player in its queue - and like wise eliminate that player from selection by other teams. And eliminate other contingent choices specifically for that player....

This would continue thru Team 10....and then back to Team 1 for assignment of a second player, etc

I am thinking I would run a series of macro steps that would sequentially assign each player until all preferences were exhausted. I have done a little macro and VBA programming but not a lot....

I'd appreciate thoughts if this should be relatively straightforward or perhaps would be too much to program. And if anyone has something similar (it would not have to necessarily be for baseball teams - it could be the assignment of any list of preferenes for multiple entities), I would sincerely appreciate the thoughts

Thanks

Dave

Here is a simplified stab at what I want to do but without using macros or vba

Teams 1-10 have a list of player preferences and these are indicated in Range A2:G11

The assignment of selections begins in cell K3

Team 1 automatically gets first choice
Team 2 gets first choice unless Team 1 picked it, which case, it gets its second choice
For all the subsequent teams, I do a series of nested if statements that assigns the value of a player that has not been previously selected

My guess is that I can program this much more efficiently using VBA....would anyone have a routine that they could start me off with to get started? I think I could modify it for my purposes once I see the basic framework

Thanks in advance f

I figured a way out to do this - I will publish when I get it cleaned up for anyone to use it. ALthough I did not receive direct help on this, I am appreciative of a lot of guys on this forum that I was able to piece together