+ Reply to Thread
Results 1 to 4 of 4

Need to link numbers to names.

  1. #1
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    249

    Need to link numbers to names.

    This is a league that I am running and I am wondering how I can automate it so I am not having to type in so many numbers.

    Can I have the Win/Lost column automatically do that depending on who wins. Lower the points that person wins.

    Every week I have to type in the names of the teams. Is there anyway to get them to automatically play each other without me typing the names each week. would it be better to do each week on a seperate tab and then have a main one with all the totals?

    It is the H2H trail tab and in red is what I want fixed.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need to link numbers to names.

    Can I have the Win/Lost column automatically do that depending on who wins. Lower the points that person wins.
    You have a lot going on there.
    Where is the Win/Loss column?
    How (and with what) would it be filled in?
    What does that last statement mean?

    Can you show some sample answers please?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    249

    Re: Need to link numbers to names.

    when the scores are entered in for the week can it automatically tally if they won or lost in that column?

    Right now I have to type all the names in for each week for who they play against. Is there a better way so I don't have to type the team names in every week and still have them play everyone the same amount of times?

  4. #4
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    249

    Re: Need to link numbers to names.

    when the scores are entered in for the week can it automatically tally if they won or lost in that column?

    Right now I have to type all the names in for each week for who they play against. Is there a better way so I don't have to type the team names in every week and still have them play everyone the same amount of times?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 10-16-2013, 10:21 PM
  2. Replies: 6
    Last Post: 04-21-2011, 03:49 PM
  3. Link Names and Add Column
    By aftabn10 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-12-2011, 10:56 AM
  4. how to link names to a table
    By jscott2711 in forum Excel General
    Replies: 1
    Last Post: 06-11-2009, 11:26 AM
  5. [SOLVED] Way to Link Tab Names
    By Karl Burrows in forum Excel General
    Replies: 3
    Last Post: 06-22-2005, 02:05 PM
  6. Way to Link Tab Names
    By Karl Burrows in forum Excel General
    Replies: 3
    Last Post: 06-22-2005, 02:05 PM
  7. [SOLVED] Way to Link Tab Names
    By Karl Burrows in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2005, 02:05 PM
  8. [SOLVED] sorting names alphabetically when names may start with numbers
    By John Smith in forum Excel General
    Replies: 3
    Last Post: 05-11-2005, 04:06 PM

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