VBA Lookup and copy problem

[jonashvid]

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....

 

[JoeMo]

Look into Filter and/or Advanced filter in Excel's Help file as an alternative to a macro.