Quote:
Originally Posted by VKiprijan
The problem with copying/pasting this module is that it applies to only one tab and I have over 30 other tabs (for Premier League, Spanish, Italian, French,...) in the same file so I don't know how it will behave then. That's why I was wondering if we could use combined O5:AN346 range instead of only B5:H346 as the first shows different goal categories.
|
So scrap this all. Instead create a table with columns like:
League, Season, Game, Team, Oponent, [optionally TeamGoals1stHalf], [optionally TeamGoals2ndHalf], [optionally TeamGoalsOvertime], TeamGoals, [optionally OpponentGoals1stHalf], [optionally OpponenGoals2ndHalf], [optionally OpponentGoalsOvertime], OpponentGoals, ...
For every game, there will be 2 rows of data - a row for 1st team, and a row for 2nd team.
In case you'll enter half-time and offtime results, the columns TeamGoals and OpponentGoals summarize matching team/opponent half-time and offtime results.
In case you enter/calculate team goals as positive numbers, and opponent goals as negative numbers, the match result for team will characterized as SUM(TeamGoals,OpponentGoals). I.e. when the team won, the result is positive, when team lost, the result is negative, and when draw, then the result is 0.
With all game data in this table, you can easily create any number of report sheets. E.g.:
Yearly League report, where use can select (using Data Validation Lists) the league and season, and the result table like you currently have is displayed (probably you need a count of hidden calculated columns in game data table, which are needed so report table fields may be calculated);
A report you asked for at start of this thread (again selecting the league and season);
Etc.