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.
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: