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