VBA - copy/paste range of cells every nth column

mfields · Oct 25th 2013

Hi,

I am trying to create a macro that will reformat my data from A2:QB24 into 9 columns starting in N28:V28 with the data from every 9 columns pasted underneath each other.

Basically, I need to start with copying Range A2:I24 and pasting it into cell N29, then copy Range J2:R24 and paste it into cell N53, etc.

Thank you so much in advance for any help!!

patel · Oct 26th 2013

Re: VBA - copy/paste range of cells every nth column

can you attach a sample file with data and desired result ?

HaHoBe · Oct 26th 2013

Re: VBA - copy/paste range of cells every nth column

Hi, mfields,

maybe you can work with this code as a start:

Code

Sub OZ183658()
Dim lngCounter As Long
Dim lngTarget As Long


lngTarget = 29
For lngCounter = 1 To 444 Step 9
  Cells(lngTarget, "N").Resize(23, 9).Value = Cells(2, lngCounter).Resize(23, 9).Value
  lngTarget = lngTarget + 24
Next lngCounter


End Sub

Display More

Ciao,
Holger

VBA - copy/paste range of cells every nth column

Participate now!

Share

Users Viewing This Thread