How to loop through rows with data as new inputs for formula

Hi All,

Apologies if this has been asked/answered before but I'm not so well versed with VBA so wouldn't know where to even begin looking for answers so thought I'd just ask.

I have a list of football results in columns A:D with the date, home team, away team, home goals, and away goals.

I would like to build something in VBA that takes the first row, moves it to specific cells to be used as inputs for a formula with the results being copied to a seperate worksheet. I already have a macro created for copying process, but each time I need to manually replace the first row of results with the one below it. This isn't a problem with 20 or so results, but I am looking at a dataset with over 10,000 matches and would like some help. Should I be looking up a certain type of loop function or?

Again apologies if this is a really common question, just have no idea where to begin

Hi Guys,

Thank you for the help! I have the copy to new sheet working fine. The issue I have is automatically updating values in cells E1:H1 (to keep with Mehmetcik's assumption). So I would like to write some code that takes first row of historic data, paste it in cells E1:H1, and after it copies that data moves to the next row until the end of the data set. I will try both of your suggestions tonight and report back how I get on. Apologies if it was a bit unclear, like I said I'm not so experienced in this area!

Thanks again!