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
cmarzahn Posts 35 Registration date Wednesday February 18, 2015 Status Member Last seen March 13, 2015 - Feb 20, 2015 at 12:09 PM
Related:
- Code to copy data from one sheet and pasting into specific cells
- Battery reset code - Guide
- How to get whatsapp verification code online - Guide
- Samsung volume increase code - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Google sheet right to left - Guide
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Feb 20, 2015 at 12:09 PM
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.
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.
