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!

Similar discussions

Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses