Copy data from one workbook to another

[Mikz]

Hi,

I want to extract data from one workbook and copy it to the another workbook.

I have a code, which copied all the data from workbook to another.

I am looking for a code which would copy only the columns A, B ,D,E,F,G,K,AP,AV,AW,AX from the source workbook and copy to the destination workbook in the columns A - K.

Below is the code, which copies all the columns from A:E. Could anyone, suggest how i could copy only the particular column i have mentioned in my destination workbook.

Please Login or Register  to view this content.

Anylead would be helpful

[mehmetcik]

Please Login or Register  to view this content.

[Mikz]

I am getting object required error

[mehmetcik]

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.

[jolivanes]

Maybe

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.