How to copy 3 columns from one excel document to another excel document already created

[eddyrcabrera79]

Hello all,

This the help I require, please help

Ex:
1 - I have 2 excel documents, 1 is called MAIN and the other is called TRANFER. Both of them are located in the same folder D:\\Data\......
2 - In the MAIN document one of the sheets is called INFO, and from that sheet I need to copy 2 columns out of a few and copy them in to the other document called TRANFER in a new sheet.
3 - also the MAIN document it has another sheet call BASIC, and I need to copy one column from there to the TRANFER document where the other 2 columns were copied in a new sheet.

Please sorry if it hard to understand, not a savvy in VBA.

Please help

thanks in advance