Use VBA in Excel to convert data to another sheet

 Blocked Profile -
how to use excel sheet of data will be converted into one to another sheet. and how to use VBA code in excel.

1 reply

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!