+ Reply to Thread
Results 1 to 7 of 7

enter players into Sheet 2 as they are picked

  1. #1
    Registered User
    Join Date
    02-27-2008
    Posts
    5

    enter players into Sheet 2 as they are picked

    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).

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Cross post.

    Please read forum rules (top of each forum, or link in my signature.)

    http://www.mrexcel.com/forum/showthread.php?t=306845

  3. #3
    Registered User
    Join Date
    02-27-2008
    Posts
    5

    My apologies

    Quote Originally Posted by pjoaquin
    Cross post.

    Please read forum rules (top of each forum, or link in my signature.)

    http://www.mrexcel.com/forum/showthread.php?t=306845

    My understanding of cross posting is posting the same question/problem on the same message board.

    I was unaware that I could not go to another message board and try to find the answer to a problem that I had not recieved on another message board.

    The reason for doing so is because I had received NO responses. So am I not allowed to seek help elsewhere? I was unaware that the two were connected. My apologies.

    Just looking for some help. Anywhere.

  4. #4
    Registered User
    Join Date
    02-27-2008
    Posts
    5
    Quote Originally Posted by pjoaquin
    Cross post.

    Please read forum rules (top of each forum, or link in my signature.)

    http://www.mrexcel.com/forum/showthread.php?t=306845
    I just noticed you are the same moderator that I responded to on the other site. So you are aware that I was unaware that this was considered "cross posting" and you are aware that I am in search for a solution to a problem.

    Why not help?

    You took the time to read two different message boards with the exact same problem. Could you offer some assistance?

  5. #5
    Registered User
    Join Date
    07-29-2014
    Location
    Quebec, Canada
    MS-Off Ver
    2010
    Posts
    2

    Re: enter players into Sheet 2 as they are picked

    Hi I am looking for a way to help my Mom's bowling league.
    She needs to divide the 64 players into a 8 teams of 6 players each. But would like that the total point (individual score) of every team be relatively the same.
    Can someone help me? VBA or Solver?

  6. #6
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: enter players into Sheet 2 as they are picked

    Welcome to the forum..

    I recommend starting a new thread to ask your question, you are likely to get more responses. Also, this thread has been dormant for 6 years
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  7. #7
    Registered User
    Join Date
    07-29-2014
    Location
    Quebec, Canada
    MS-Off Ver
    2010
    Posts
    2

    Re: enter players into Sheet 2 as they are picked

    Thanks...I'm a nub...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1