Hello everyone, I have a specific group of columns see image "New Main Price Pages A and B" in which I have 4 columns and Row 1 as an example, every 42nd Row following this in the sheet from Row 1 to Row 16633 there is another 4 cells in the same columns that I need to copy, and then paste into see image "Style Rounding" Row after row.
So the Style rounding sheet would receive the copied cells from "New Main Price Pages A and B", the first Row 1 from column AK, AL, AM, AN, would be pasted into the first row of "Style Rounding", then 42 Rows down in "New Main Price Pages A and B" which would be Row 43 and columns AK, AL, AM, AN, would be copied and pasted into "Style Rounding" Row 2 and so on until all of the range Row 1 through Row 16633 is copied and pasted into "Style Rounding".
There are formulas in the copied cells so they need to be pasted as "Values".
The main name of the workbook is "Version 85 111821.xlsm"
Is this something that can be done in a VBA Macro?
Thanks in advance for any help on this.
I'm so so working at changing VBA Code but not at creating it.
So the Style rounding sheet would receive the copied cells from "New Main Price Pages A and B", the first Row 1 from column AK, AL, AM, AN, would be pasted into the first row of "Style Rounding", then 42 Rows down in "New Main Price Pages A and B" which would be Row 43 and columns AK, AL, AM, AN, would be copied and pasted into "Style Rounding" Row 2 and so on until all of the range Row 1 through Row 16633 is copied and pasted into "Style Rounding".
There are formulas in the copied cells so they need to be pasted as "Values".
The main name of the workbook is "Version 85 111821.xlsm"
Is this something that can be done in a VBA Macro?
Thanks in advance for any help on this.
I'm so so working at changing VBA Code but not at creating it.