Macro To Loop From Last Row To Row 4

It will be good if you explain your requirement a little more and maybe even attach a sample file so we can test on it.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Attachment 250334Attachment 250335Sure, I've attached the two workbooks. I need to get data from "Database Test" into "Blank Team Sheet". The team I'm trying to copy the data for at the moment is Fulham- there are only three games but my code is only able to look up the last game (v Arsenal) and get info for that from "Database Test". The data I am looking for specifically are Total Shots, Shots on Target, Shots OFf Target, Total Home Corners and Total Away Corners. These will be filled into "Blank Team Sheet" based on the data from "Database Test".

Eventually the goal will be to loop through all the teams and fill the blanks for all the matches...