Quote:
Originally Posted by oman19
Will this be auto-filling in the schedule now?
|
Not when you enter your matchups on the Template sheet. I wish there was a way to do that...however since I have no clue as to how many teams/games a person may want to have in a season, I'm unable to figure how that would be possible.
Doesn't mean I've given up on the idea though. Just haven't figured out how to do that yet.
If anyone has any ideas, I'd sure love to hear them.
I have fixed the Schedule sheet so that when you copy a team's yearly schedule from the Template sheet and paste it into the Schedule sheet, it ignores their away games and off days. This eliminates any possibility of duplicate games on the same day as well as eliminates the need of manually deleting data you don't want..
This is possible as a team's away game is always the other team's home game.
It now works using A or H for the 4th letter in the team's name like so:
BOSA or BOSH...
Remembering that the second row of the template sheet is always the home team, any team below that with H as the 4th letter in the name (BOSH) is always a home game.
A team with A as the 4th letter in the name (BOSA) is always an away game and when pasted into the Schedule sheet they are ignored so you no longer have to manually delete those.