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 :
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 :
HTML:
Sub btnS()
Selection.Copy Sheets("destination").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)Worksheets("destination").Activate
End Sub