Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2015
    Thanked 0 Times in 0 Posts

    Sports Pool Web Download

    OK, Excel pros. Looking for a solution for Excel (2010). I run a 30 team hockey pool using Excel.
    Currently, I import player stats from a website to an Excel Work sheet and then transfer those individual player stats to each team accordingly. Each team is on the same Work book, but cannot make permanent links from the website download, since players move around in the work book (trades, cuts, etc). In addition, the download from the website will always change as well.
    Is there a way to make this all a little easier? Thanks.
    Last edited by JACCANUCK; 2015-01-26 at 08:41.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Pa, USA
    Thanked 776 Times in 707 Posts
    ...the download from the website will always change as well.

    When you say the download changes, are you indicating that the players names and stats will be placed in different cells throughout the sheet (different cols and rows) or that they will always be in the same range but a different order?

    Worst case scenario is that this can be done in a semi-automatic fashion. Select a player then click a button to run a macro to search all the spreadsheets for the player and when found, paste the stats. If the players names are in a list with a consistent range, for example always Cells A4 through A225, and in any order, then this could be more automated by cycling through the players names, locating them on other sheets and transferring the stats.

    Without a sample worksheet with a sample download, it is difficult to say more.


Posting Permissions

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