On Sun, 10 Jun 2012 10:38:10 +0000, JackT91 wrote:

Also, while i have your attention, is there a way i can sort the points
table so the team with the most points is at the top and sorts itself
when the points change? Even though every cell on those rows have
formulas(except for the team names).

You could use an event-triggered macro to do that. The details of how to set that up depend on the details of your worksheet, which you have not yet chosen to share with us.
I would suggest either posting a comprehensive example here, or posting a sample workbook on a publicly shared website and posting the link here.