[Prototype]

Did a quick skim to see if this had been asked yet, didn't see it.

I'm in a Sim League that is heading into it's draft right away. What I'm trying to do is come up with an Excel sheet that keeps track of who is drafted and by what team.

There are two parts to this.

I have two sheets so far in the document I'm working on. One has the Draft Order of the teams in the league, the other has the results of the NHL, including the player's vitals.

I have a drop down menu in the sheet with the draft order which has each player, alphabetically. What I'm trying to do is have the vitals pre-populate after selecting the players name.

What I'm also trying to do is have the Sim League draft ranking populate in the sheet with the NHL results as well.

While the draft is on going, I want to post this to google docs so that the entire league has something to look at while the picks are being made.

I hope this all makes sense. If you need more info, feel free to post, or PM me.

Thanks in advance.