Copy cells H - L and Paste to A - E on next line

[abcisme]

I have a worksheet which has columns A-L

I am using this macro to insert a blank row between each existing row:

Please Login or Register  to view this content.

What I need is a macro that will select the cells H-L for each row, cut them and paste them in the A-E cells of the following line (which is blank).

I need the macro to do this for each line until the end of the file.

Is this possible?

Any help would be greatly appreciated!

[JieJenn]

Try

Please Login or Register  to view this content.

[abcisme]

Thank you for your help! This is Close! But it seems to paste it on the same row, instead of the following row.

[JieJenn]

O. Just add +1 before rni

Please Login or Register  to view this content.

[abcisme]

Ok, that almost works, too. But what's happening now is that the cells in the blank rows are copying down also, so the first few columns of the existing rows are ending up blank..... I guess I just need it to be adjusted to work on every other row. (only odd numbered rows)

[abcisme]

I think I figured it out!

Please Login or Register  to view this content.

THANKS A MILLION!