Code to copy data from one sheet and pasting into specific cells

[Closed]
Report
Posts
1
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
February 18, 2015
-
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
-
Hi all,

I have two worksheets. Namely 'Worksheet Values' and 'Worksheet Final'.
'Worksheet Values' contains all the data that I want to insert in the other worksheet. The data is in one column i.e A1, A2, A3.....A12
Now I want to copy A1 into new worksheet called 'Worksheet Final' cell B1, A2 into B5, A3 into B9 and so on... After every 3 cells I want to insert the data. Can someone assist me how to do this because volume of data is huge.

Regards
Thanks a lot

1 reply

Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
If I understand, you want to copy data but into a sheet with rows in between. Why not copy the data into the second sheet and then write or record a short macro that inserts rows between. I recorded this as an example
Sub Macro1()
'
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
End Sub

Set it on the value in the second row. Run the macro once.
Then hold down F4 (Repeat operation) until it hits the bottom of the column.