VBA for copy and paste after last column of another worksheet


I am looking for a macro code for copying data from a column of one worksheet and to paste the same in last empty column of another worksheet.

Details with Videos will be applicable



Hello kaushik,
Welcome to the Teach Excel forum. By all means, browse our site and take whatever code you find. It's free, and much of it is presented with videos. Once you have found the code you want and need help applying it to your specific problem you can ask here and we can probably help you.
Please take note of the sequence. First you write or find the code. Then you try to use it. And only if that fails you come here, publish your code and ask your question. For now, you appear to be two steps short of qualifying.
I hope to see you again soon.
Variatus (rep: 4864) Jul 25, '21 at 3:33 am
Add to Discussion




Suggest you try these two tutorials:  Find the Last Column with Data in Excel VBAt and Macro to get Data from Another Workbook in Excel to which you'll need to add Range("<<destination cell>>").PasteSpecial or suimilar to get the column into the destination workbook.

If you have problem in completing your code, fell free to ask again (as Variatus has said).


Answer the Question

You must create an account to use the forum. Create an Account or Login