Copy 2 different columns from one workbook to other after end of the data

Hi There,

I need to copy column A and B from a worksheet (tab – Abslayer_BCN) and paste the values in a separate spreadsheet at the end of the E : F columns ( Tab - Abslayer_SAP_BCN). When I say End of the E:F column which I mean I want to paste these immediately after the data where blank row appears. Because I am collating the data after every batch run in this sheet.

I am using 2003 version. When I run the macro the both the worksheets will be open.

I am trying the below code which is not working so I need some expert’s help to resolve this.

Please Login or Register  to view this content.

I appreciate every single reply and how everyone tries and help others in this forum. This is really amazing.

Thanks,
Su.

That works perfect.

Thanks very much Patel.

Hi Patel,

The code works for just one row.

For eg: it just copies the first row from the batch extract to my tool.

Attached is the sample.

Try this one

Please Login or Register  to view this content.

Thanks AB33.

This code works for all. Thank you very much.

Hi AB33,

I am trying the below code which is pretty same logic as above.

It copies A:B to E:F perfectly.
After I am trying to copy B (from batch extract) to G(Test Forum Sample) and C(from batch extract) to A (Test Forum Sample) which copy nothing.

Can you please correct me if I am doing anything wrong.

Please Login or Register  to view this content.

Can anyone help with this please?

Hi Patel,

Thanks for your kind reply.

But this only copies A and B from Batch_2_Report.xls to E:F in Test Forum - Sample.xls.

It does not copy B and C from Batch_2_Report.xls to G and A in Test Forum - Sample.xls....:-(

Thanks,
Su

Finally this does what I expect.

Your genius. Thank you loads buddy.