Excel help required

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fattytrellis
    SBR Rookie
    • 02-16-12
    • 18

    #1
    Excel help required
    Hello guys, hope you are all well.

    Was just wondering if someone could maybe help me on this problem I have encountered on Excel.

    I basically have a sheet that runs my calculations for my betting model. On another sheet I have the data that I input by hand into my model.

    I have 2 parts of the model, one for the home team and one for the away.
    I was wondering what the easiest way would be to automate this data entry process.

    I have managed to create a drop down list for the home and away sides with all the team names and ideally I would be able to select the teams and the relevant data is filled in. However, I am unsure of how to do this.

    Any help would be greatly appreciated.

    Thanks very much
  • mark49
    SBR Rookie
    • 03-03-08
    • 42

    #2
    How you can automate the data entry will depend on where you are getting the data from. It could be possible to scrape or import the data from a website automatically. A table from somewhere like ESPN etc takes seconds.

    To bring up the data relevant to a specific team should be easy enough, just some simple lookup formulas.
    Comment
    • fattytrellis
      SBR Rookie
      • 02-16-12
      • 18

      #3
      I have just been experimenting and have worked out what I needed to do! Thanks for the reply though!
      Comment
      SBR Contests
      Collapse
      Top-Rated US Sportsbooks
      Collapse
      Working...