Looking for some hel from an excel guru

Search

New member
Joined
Mar 11, 2008
Messages
88
Tokens
Looking for some help from an excel guru

I'm looking to work on some sheets over the winter during some downtime at work and wondering if it is possible to program this macro or use some other method to perform the task.

I am looking for a site where I can import the match-ups with teams and lines only which I will have in sheet 1.
In sheet 2 I am looking to import stats for every team via statfox.

Now the tricky part that I am wonder about. How difficult/possible is it to have sheet 2 sort for certain stats for each team listed in sheet 1 and place them in the appropriate column for that team in sheet 1.

ex for Buffalo/Ball st:
Sheet 1 would have the team names in A2/A3 with the line for that team in B2/B3 and then have a column for say total offensive yards per game (C2/C3), total yards allowed per game for each team (D2/D3), ppg (E2/E3), etc.

For sheet 2 I would like to auto import the updated stats from statfox upon opening and have it search for each of the listed teams on sheet 1 and then take the data out of (offensive yards per game, defensive yards per game etc) and automatically put that data into the appropriate space next to each team on sheet 1.

I'm sure this will consume a ton of my time but I should have plenty of time in the upcoming months. Just wanted to make sure this can be done before starting the journey. Any help/guiding to some reading on the subject would be greatly appreciated.


Thinking something on sheet 1
Thanks in advance.
 
Last edited:

New member
Joined
Mar 11, 2008
Messages
88
Tokens
Thinking a formula in the A column of sheet 1 something with IF(a1=arizona then I would have a formula to pull the stats from the appropriate columns of sheet 2 which would remain constant and in alphabetical order (if A1 was indeed arizona). I would have every team in that initial formula (with their specific column/row for the needed stats) and insert it into each row of column A. Would that work if I had each team in that formula for every row in that column so it would pull data from sheet 2 corresponding with the team name on sheet 1?
 

New member
Joined
Feb 13, 2007
Messages
248
Tokens
Before doing anything make sure that the info you are trying to get is not already available for sale. There are quite a few sites that sell excel data that are loaded with stats on a game by game basis.
 

Member
Joined
Feb 4, 2005
Messages
1,198
Tokens
you can use vlookup which will help a lot. Get your sheet together will the data in it and then I can take a look at it and try and plug some formulas in for you.
 

Forum statistics

Threads
1,106,144
Messages
13,433,398
Members
99,280
Latest member
dukes007
The RX is the sports betting industry's leading information portal for bonuses, picks, and sportsbook reviews. Find the best deals offered by a sportsbook in your state and browse our free picks section.FacebookTwitterInstagramContact Usforum@therx.com