I thought I'd offer up a workbook that may help some others out. I've taken particular stats from Soccor stats & then created my own format using Vlookups. I've only done it for 5 leagues because that was enough to go through on match day for me.
As other people who have kindly put up some of their workbooks have pointed out, to get up to date data you just need to refresh which is found within the Data tab. You can change the teams by clicking the drop down box and this will change all relative data within that sheet for that team. Hope somone gets something from it.
Football stats excel workbook
Hi.
I've downloaded the worksheet. I pressed refresh but then got a host of error messages. The first 2 quieries appear to be OK but the remaining ones appear to have lost the link. Possibly the source data has moved?
I look forward to being able to try it.
I've downloaded the worksheet. I pressed refresh but then got a host of error messages. The first 2 quieries appear to be OK but the remaining ones appear to have lost the link. Possibly the source data has moved?
I look forward to being able to try it.
- ilovepizza82
- Posts: 504
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Doesnt even work.