Premier League Stats

[gbWildy]

Hello

I am trying to setup a spreadsheet of the english premier league, i have done two workbooks, the 1st being the table, and the 2nd being a summary of the results. i want to be able to input the data in the results so the table will automatically update itself and that is where i am stuck as i dont know how to do the formulas.

Any ideas anyone?


table.jpg

Results.jpg

[VBA Noob]

This link may help

http://www.xldynamic.com/source/xld.LeagueTable.html

VBA Noob

[gbWildy]

yes, that is exactly what im trying to do myself (and you just happen to pick the season my team finished bottom of the league hehe).

what i want to know is the formulas i need for the number of wins/draws/loses and goals scored/conceded updated automatically after entering the results

[VBA Noob]

Download the file.

VBA Noob