Previous Topic Next Topic

Use VBA in Excel to convert data to another sheet

Closed
SAISUMA - Updated on Jan 18, 2018 at 08:23 AM
 Blocked Profile - Jan 18, 2018 at 05:31 PM
how to use excel sheet of data will be converted into one to another sheet. and how to use VBA code in excel.

1 response

Answer 1 / 1
Blocked Profile
Jan 18, 2018 at 05:31 PM
Its as simple as: 

Private Function copyRow(whatrow, whatsheet)
ActiveSheet.Paste Destination:=Worksheets(whatsheet).Range("A" & whatrow)
Application.CutCopyMode = False
End Function

Let us know if you get stuck.

BTW, I will not produce a TURN KEY solution for you , but will assist when you are stuck!