MuskokaSloPitch
New Member
This is my first time asking a question, so if I'm missing something, please let me know.
I've been asked to create a website for my husband's baseball team and I have figured out all the formulas except one.
They would like to have the schedule available in two ways:
1) the main schedule where all the games are included for all the teams
2) you can click on the individual teams name and ONLY see the games for that individual team.
How do I extract simply THAT data?
Here's what my spreadsheet looks like:
Sheet is labeled: "Schedule"
Data goes from 3:275
Column A: game number (1:273)
Column B: Date (23/05/2016: 12/09/2016.. multiple games on each day)
Column C: Time (6:30-8:50)
Column D: Diamond (A:F)
Column E: Team names for HOME (ex. BCM)
Column F: Home Score
Column G: Points
Column H: Team Names for AWAY (ex. CCC)
Column I: Home Score
Column J: Points (0:3)
What I need in the new sheet is each time an individual team would play (ex. all BCM's games)
Game number (A),
Date IN ORDER (B),
Time (C)
Diamond (D)
Who they are playing against (either e or h)
The Score (F and I)
Points (J)
I believe I need a new sheet for each of these schedules (as I will be uploading the individual sheets to the website).
I am not at all familiar with macros, so a formula would be much appreciated.
THANK YOU SO MUCH IN ADVANCE!!!!
Cheers,
S
I've been asked to create a website for my husband's baseball team and I have figured out all the formulas except one.
They would like to have the schedule available in two ways:
1) the main schedule where all the games are included for all the teams
2) you can click on the individual teams name and ONLY see the games for that individual team.
How do I extract simply THAT data?
Here's what my spreadsheet looks like:
Sheet is labeled: "Schedule"
Data goes from 3:275
Column A: game number (1:273)
Column B: Date (23/05/2016: 12/09/2016.. multiple games on each day)
Column C: Time (6:30-8:50)
Column D: Diamond (A:F)
Column E: Team names for HOME (ex. BCM)
Column F: Home Score
Column G: Points
Column H: Team Names for AWAY (ex. CCC)
Column I: Home Score
Column J: Points (0:3)
What I need in the new sheet is each time an individual team would play (ex. all BCM's games)
Game number (A),
Date IN ORDER (B),
Time (C)
Diamond (D)
Who they are playing against (either e or h)
The Score (F and I)
Points (J)
I believe I need a new sheet for each of these schedules (as I will be uploading the individual sheets to the website).
I am not at all familiar with macros, so a formula would be much appreciated.
THANK YOU SO MUCH IN ADVANCE!!!!
Cheers,
S