Repeat from where stopped (excel)

[kteicher]

I have a worksheet in excel.

I want to copy part of row 2, and move it to row 1, then go to row 3 and move it to row 1.

That is all fine.

Now, when I turn on repeat I want it now to start at row 5, copy and move it to row 4, then go to row 6 and move to row 4.

When I turn on repeat it goes back to the beginning instead of worthing its way down the spreadsheet.

Any advice is appreciated.

Thanks!

[forumsupport]

Hello,

What you can do is,

. Before you start the recording, keep selected the cell you want to copy from i.e. in your case row 2.
. Start the recording.
. Copy the selected cell, move it to row1, go to row 3 and move it to row1 using keystrokes.
. At the end, move the cursor to row 5 using down arrow keys.
. Stop the recording.
. Set repeat property of macro as per your requirement.

When you will run this macro, it would copy the currently selected cell, will perform the actions you recorded and at the end will move cursor to row 5 so that in next repeat the process would start from row 5.

Hope that helps.