need help writing macro to merge two files

[bhuvana23]

I have two files one a larger report Sample Charges and Sample Dispute that I need to merge with each other. I need only two columns from dispute file( Minutes Used MSG/KB/Min/MB Used) merged with the charges file.
Any help is appreciated.

Thanks

[Pepe Le Mokko]

Maybe this add in will help

[rvasquez]

Hello there,

Below is a code that will add the B and C columns from the Dispute workbook into columns R and S of the Charges workbook.

To insert this code go to the developer tab on the Excel menu. If you do not have it go to File --> Options --> Customize Ribbon --> and then in the far right column select the Developer option and select Okay.

Next select the Macros option. In the Macro Name: text box provided type macro1 and then select Create

Paste the below code in between the Sub and End Sub that appears.

Please Login or Register  to view this content.

As stated in green above you will need to change the file path in the code to the filepath you have the document saved on your computer.

You're final code should look like this

Please Login or Register  to view this content.

Let me know if you have any questions!

Finally close VBA and then go back to macros and select macro1 and click Run.

Thanks!

rVASQUEZ

[bhuvana23]

thank you so much! that worked like a charm! i can now avoid tedious manual merges!!