Several of us in our office have a fantasy golf league and we administrate it off-line using an excel spreadsheet (we haven't found a free website that lets us tailor the rules to the way we like it.)
Anyway, it is a salary cap format, meaning that only one golfer can be on one team at a time. To keep track of this, one of our worksheets has a list of all the golfers. That same worksheet also has every team's roster. For all golfers that are on someone's roster, I manually highlight that same name in the master list of golfers so it is easy to see who is taken and who is available.
What I'd like to be able to do is have it automatically highlight that golfer's name in the master list when it appears in the individual team roster's page (and conversely un-highlight the name when the player is dropped). But I don't know what the VBA code should be.
Below is an example of how it looks:
you can see the master list on the left and the team rosters on the right. Any help would be greatly appreciated. Thanks!