I pulled in this table
http://www.nhl.com/ice/standings.htm...32014&type=LEA
From there I used the method from your example **'away team statsSheets("Sheet1").Cells(lastrowsheetone + 1, 2) = Sheets("Sheet2").Cells(findmatch + 1, 1)**
To copy the place,team,gf,ga
Something like this
Place Team GF GA Streak 1 ST. LOUIS 226 152 Won 3
I now need to add a loop to get the same thing 30-31 times.
This can all be done after we are completed with your example.