VBA code for copy data from closed workbook to "Data " sheet of current workbook

Dear Members,

I am looking VBA code for copy data from another workbook to last row of "Data " sheet of current workbook . I have to copy data as per below.

copy from "I" column of another workbook and paste to "A" column of current sheet
copy from "A" column of another workbook and paste to "B" column of current sheet
copy from "B" column of another workbook and paste to "C" column of current sheet
copy from "C" column of another workbook and paste to "D" column of current sheet
copy from "N" column of another workbook and paste to "E" column of current sheet
copy from "O" column of another workbook and paste to "F" column of current sheet
copy from "R" column of another workbook and paste to "G" column of current sheet
copy from "P" column of another workbook and paste to "H" column of current sheet
copy from "Q" column of another workbook and paste to "I" column of current sheet


I required option for select file.


Any help is appreciated


Regards,
Nandkumar S.

Hi,

Can I just ask you about the code you've "started to write"?

What, for example, are each of the variables you've declared?

Regards

No sir .I can't write next to it. I have not good knowledge of VBA

Thanks for reply

bump post .

But you said that you started to write the code? I just wanted to get an understanding of the reasons for your declarations so far.

Regards

Respected sir,

I had browse for vba code on net, and tried to edit it as per my requirement. But I couldn't.

bump post .

bump post .

Three bumps, already?

And I notice you've now removed "your" attempt at the code from your original post...

Any body has solution on this

Hi members,

I have recorded macro. Please find below.

Please Login or Register  to view this content.