Copy in a loop down column

I need the full code to perform the following portion of the code every 7 rows in column JI starting in cell J104 then in JI111 ect..

Please Login or Register  to view this content.

I tried to write a code to loop down the entire column JI but I am having trouble doing so. How can I modify the code to work?

Please Login or Register  to view this content.

Hi rhudgins

I'm a little unclear but see it this code does as required

Please Login or Register  to view this content.

John

Hi rhudgins

This line of code

Please Login or Register  to view this content.

says to move 10 columns to the left on the same row

Please Login or Register  to view this content.

and then resize that cell range by 1 row and 10 columns to the right

Please Login or Register  to view this content.

You cannot resize by negative values so I've moved to the left then came back to the right.

Effectively what it says is move the cursor 10 columns to the left then select that cell and the nine cells to it's right. Clear as mud?

John

Hi rhudgins

Well again, it depends of your workbook structure.

Are the two worksheets the only worksheets in the workbook? If so, it matters not what the worksheets are named.

If not, are the two worksheets always distinctively named and always have those distinctive names? If so, what are the worksheet names?

John

Hi rhudgins

Try this

Please Login or Register  to view this content.

Let me know of issues.

John

Hi rhudgins

You're welcome. If your issue is solved, please mark it as such. A click on the scales is always appreciated.


John