macro to copy specific columns of selected rows to another sheet

[acmehra]

Hi All ,

I am a beginner in vb. I want to copy data of rows selected by user to another sheet . But data from column A, B and E of the source sheet should be copied from the selected rows.

I am able to write the code which can copy whole row to destination sheet but I need help to copy data from specific columns only. Please help.

Below is my current code :

Sub btnS()
Selection.Copy Sheets("destination").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)Worksheets("destination").Activate
   End Sub

 

[acmehra]

Amazing . It worked .

thanks a ton All.

 

[Fluff]

Glad we could help & thanks for the feedback