Use VBA in Excel to convert data to another sheet [Closed]

Report
-
 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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!