Hey
I am working on a Premiere League soccer statistics sheet, I have all the data in this format:
Column A: Date
Column B: Home Team Name
Column C: Home Team goals
Column D: Away Team goals
Column E: Away Team Name
Now I would like to be able to extract some data from the statistics sheet. For example I would like to see the result of all the matches where Arsenal and Chelsea played against each other.
I am thinking a macro that looks through all the data and copies the row where Arsenal and Chelsea are playing against each other. How would I go about this, any suggestions....
I am working on a Premiere League soccer statistics sheet, I have all the data in this format:
Column A: Date
Column B: Home Team Name
Column C: Home Team goals
Column D: Away Team goals
Column E: Away Team Name
Now I would like to be able to extract some data from the statistics sheet. For example I would like to see the result of all the matches where Arsenal and Chelsea played against each other.
I am thinking a macro that looks through all the data and copies the row where Arsenal and Chelsea are playing against each other. How would I go about this, any suggestions....
