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

Closed
m3faizan Posts 1 Registration date Wednesday February 18, 2015 Status Member Last seen February 18, 2015 - Feb 18, 2015 at 12:31 PM
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Feb 20, 2015 at 12:09 PM
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

cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 7
Feb 20, 2015 at 12:09 PM
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.
0