+ Reply to Thread
Results 1 to 3 of 3

Auto updating teams.

  1. #1
    Registered User
    Join Date
    11-11-2012
    Location
    Bolton, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Auto updating teams.

    Hello,

    Apologies if this is the wrong place to post, or has been answered before but this is my first post and im not sure how to explain what I am trying to do so couldn't search for it.

    I currently have a spreadsheet with a list of Team Members next to a Team Manager name on a sheet named data. There are anywhere between 10 - 20 teams at anyone time with between 8 and 20 members.

    I then have separate sheets for each team to display some stats. It all works perfectly, the only issue I have is that when it comes to team changes, i have to manually update each team sheet.

    What i am trying to do is use a kind of vlookup that checks the Team Manager name in cell $A$1 of the individual team sheets and then looks up the team from that data sheet. But any lookup i use only lists the first team member. I know the teams will never be bigger than 25 so I think i need 25 formulas in the cells to ensure everyone is displayed.

    Im not sure if this is making any sense so i have attached a sample sheet.

    Any help would be greatly appreciated.

    Many thanks
    Stuart.
    Attached Files Attached Files
    Last edited by parkiee1981; 11-21-2012 at 01:57 PM. Reason: This has not been solved.

  2. #2
    Registered User
    Join Date
    04-17-2012
    Location
    No, Thanks
    MS-Off Ver
    MS 2010
    Posts
    14

    Re: Auto updating teams.

    Hello,

    Please see the modified workbook attached.

    I've added a column to the data page that basically creates a unique line ID for each player based on their manager.

    Then in the page for team A, you just reference that with an INDEX.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-11-2012
    Location
    Bolton, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Auto updating teams.

    Wow! Thank you so much for such a speedy response.

    This is perfect! I guess I need to brush up on the index function.

    Many thanks again.
    Stuart.

+ 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