Slight modification to copy paste loop

The following code copies data entries in a loop on two seperate worksheets starting in row 5 and then skips every 5 rows to copy the next data entry. Can someone help me change the code to start in row 50 and then skip every 5 rows for the next entry?

Please Login or Register  to view this content.

I think you'd just change the line that says i = 6 to i = 51.
Did that work?

Sorry, I must've mis-interpreted your request. I am not familiar with that syntax (having a (5) at the end), someone else will have to step in.

Oh, I got it. The 5 offsets the destination row by five. Cool, I never knew that option was available, I'd just had added 5 to the row.
Anyway, it seems you are asking for the destination to start on row 50, then jump 5 each time. A quick fix would be:

Please Login or Register  to view this content.

Sure. You have to look at the whole shtL.Cells(Rows.Count, 26).End(xlUp).Row
This says start at the bottom of the shtL sheet. In column 26 (Z), go up from the bottom until you encounter a cell that has a value or formula. The .Row at the end indicates take the row number of that cell. So the whole thing together just finds the last row in Column Z that is being used.

You can also start at the top with something like shtL.Cells(1, 26).End(xlDown).Row. This would find the first blank cell after row 1 and return the row number. Get it?