I pulled in this table
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
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.
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
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.