calculating the unknown

[bigpoly60]

I can perform simple tasks, but I am trying to figure out how to do the following:

I am the commish of a new fantasy football league.

On Sheet 1, I have all the WR, RB, and QB names. Each name is listed under the appropriate position. No particular order.

On Sheet 2, is the draft order for 12 teams. 23 rounds. 1-12,13-24,25-36,etc....

On Sheet 3 thru Sheet 14 is each individual managers team roster. There are specific columns and order I am needing the name entered on Sheet 2 to appear on these 12 sheets.

On Sheet 3 there is 1QB, 2RB, 3WR, 1TE, 1K, and 1 Def. The other 14 spots are for bench players.

If Sheet 5 player drafts a RB first, I want to enter that players name in the draft order and have it appear on that managers sheet at that players position.

Does this make sense? Can someone help?

[NBVC]

Please revise your title to something more meaningful and please do not post duplicates.

[bigpoly60]

Sheet1
Column A = RB�s names (50 names)
Column B = WR�s names (75 names)
Column C = QB�s names (36 names)
Column D = TE�s names (24 names)
Column E = K�s names (24 names)
Column F = Defense�s (24 names)

Sheet2
Managers Names are Columns B-G, Rows 1 and 26.
This allows 23 rounds of drafting.

Sheet3 thru Sheet14
Each individual Managers Team
Column A = RB�s
Column B = WR�s)
Column C = QB�s
Column D = TE�s
Column E = K�s
Column F = Defense�s



what I am trying accomplish is the following:
Enter the players in order of how they are drafted on Sheet 2. Then have that info. reflect on each managers worksheet at the position they play.

Example: Tomlinson selected first by T1. Peterson selected by T2. I enter their names on Sheet 2 and those name also appear on the managers worksheet under the position they play. In this case it would be RB (column A). In the third round, Owens is selected by T1, and Owens appears on T1's worksheet under WR (column B).

[NBVC]

I still don't see a title change...

Thread locked...please repost thread with appropriate title.