I am starting a new Fantasy Football League. I am wanting to be able to enter players into Sheet 2 as they are picked. And I am wanting those picks to be simultaneously placed on Sheets 3-14 according to their position. Sheet 1 is a list of names according to positions. A more detailed explanantion is entered below. Can someone help?
heet1
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).
heet1
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).