Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

VBA for copy and paste after last column of another worksheet

0

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

Answer
Discuss

Discussion

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: 4889) Jul 25, '21 at 3:33 am
Add to Discussion

Answers

0

Kaushik

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).

Discuss


Answer the Question

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