VBA copy multiple lines within For Loop

How would you go about printing information on a second line while still in the same "a" in the for loop?

Referencing the below code, away_ml should be printed in (4,5), but home_ml should be in (5,5). Currently, the code I have prints the first line correctly, but then does not print the "a+1" like I am intending.

I don't think I can use the Step method in the intial for loop line (For a=4 to g step 2) as I would miss rows that I need to pull information from.

Uploaded is an example file with it correctly copied on the right hand side of the sheet. Below is my current code.

Please Login or Register  to view this content.

Originally Posted by Norie

You should use another variable for the destination row as it's no always the same as the source row.

Please Login or Register  to view this content.

This worked perfectly - thanks for the insight!