Baseball League Table with Auto-sort Function

[davo3286]

I have a Baseball Fixtures/Results and League Table document here that is very nearly finished thanks to what I already achieved myself and then a lot of really good help on here which is hugely appreciated!


The only issue now being that when I input new results into the document, the auto-sort doesn't appear to work and then the rest of the data doesn't seem to match up neither. I believe that the formulas are not moving with the auto-sort where as the team name etc. are.

I have spent hours changing the formulas, trying to use absolute references etc. and the only thing I can think of is that maybe due to the combination of code and formulas they are deciding to 'fight' one another???

After acquiring a full head of grey hair trying to figure this out, I have decided to make a new post.

Would it be worth while removing the formulas and trying to figure out the code to get the values that the formulas are working out?


All suggestions welcome!

[xlnitwit]

Could you be specific as to what doesn't work when you do what?

If you're sorting data, I suggest you remove sheet names from formula references when they refer to the sheet the formulas are on. For example this one on the LEAGUE TABLE sheet
=COUNTIFS('Fixtures and Results'!F:F,'LEAGUE TABLE'!E6,'Fixtures and Results'!G:G,"L")+COUNTIFS('Fixtures and Results'!L:L,'LEAGUE TABLE'!E6,'Fixtures and Results'!K:K,"L")
should be
=COUNTIFS('Fixtures and Results'!F:F,E6,'Fixtures and Results'!G:G,"L")+COUNTIFS('Fixtures and Results'!L:L,E6,'Fixtures and Results'!K:K,"L")
or it can cause you issues when you sort.

[davo3286]

I've just changed the formulas to remove the sheet names and now everything is working perfectly! Really appreciate your help on this it's had me pulling my hair out!