Copying and Pasting of every nth Column of Data to a new location in Same Worksheet

[haer]

Hi all,

Im looking to do a macro to copy a range of data (of every nth column) and paste it to another series.

I have a data set (each comes in 3 columns) comprising of Ch1, Ch2 and Ch3. I would like to group the Ch1, Ch2 and Ch3 separately.

For Channel 1,
The macro would aim at copying B2:B21 and copy it to B26:B45, follow by E2:E21 and copy it to C26:45 and so on and so forth.

For Channel 2,
The macro would aim at copying C2:C21 and copy it to B49:B68, follow by F2:F21 and copy it to C49:68 and so on and so forth.

For Channel 3,
The macro would aim at copying D2:D21 and copy it to B71:B90, follow by G2:E21 and copy it to C71:90 and so on and so forth.

I have attached an excel sheet with the desired outcome where the data have been separated. Hope someone can help me with a macro as tons of more data are coming.

Appreciate your help and thanks in advance!

[Mandeep Baluja]

Sort it via Rows and copy it 3times(Ch1,ch2,ch3) easily below simple task to do ?? Do let me know if you wish macro only for doing this

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo

[haer]

Hi Leo,

Thanks! It works perfectly.

However, I have a question should the step be 2 instead of 3 as above, which part of the code do i modify? (eg. there is only Ch1 and Ch2 instead of Ch1, Ch2 & Ch3)

Thank you for your kind help.

-Haer

[LeoTaxi]

Nothing to modify, it works with every step.

Kind regards
Leo

[haer]

Nothing to modify, it works with every step.

Kind regards
Leo

Thanks Leo!

One more question, i added a row above the the existing row 1, moving existing row 1 to row 2. When i ran the macro, it seems its compiling vertically down instead of horizontally to the right for the 3 channels.

I would like to include the added row at the top of the channel number too when copying it down. For eg. Location, Ch1, follow by the values vertically down.

How do i rectify this?

Thanks!

-Haer

[LeoTaxi]

Please Login or Register  to view this content.

Kind regards
Leo