Copy columns and paste them in another sheet every nth columns

[johnjohnk]

Hi all,

I am very new to VBA and I am trying to do something that I am sure is possible, but I couldn't find what I want in any of the forums.
This is my first post (ever), so if I might miss some information.

Basically I just want to copy the columns on one sheet (A to ...) and paste them in another sheet (in the same workbook), but every 4 columns, starting from column D.

Can anyone help me on this?

Thanks.


PS: English is not my mother tongue so my apologies if there are any mistakes that may burn your eyes .

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[alansidman]

try this:

O

Please Login or Register  to view this content.

[johnjohnk]

Thanks for your help.

xladept: Here is the excel sheet. Sheet 1 shows the data that I want to be paste in sheet 2 every 4 columns, as I manually did here.

alansidman: I tried your code but it seems to only copy the first column

[alansidman]

I've applied the code I provided to your worksheet and after deleting the first row of your sample data, it worked for me. Row 1 was blank and the code looks to that row to determine the number of columns to copy.

[johnjohnk]

Thanks for your help!!! That's all I needed !

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.