Code to copy data from one sheet and pasting into specific cells
Closed
m3faizan
Posts
1
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
18 February 2015
-
18 Feb 2015 à 12:31
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 20 Feb 2015 à 12:09
cmarzahn Posts 35 Registration date Wednesday 18 February 2015 Status Member Last seen 13 March 2015 - 20 Feb 2015 à 12:09
Related:
- Code to copy data from one sheet and pasting into specific cells
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- How do i find a specific video on youtube - Guide
- How to copy sheets from one work book to other - Excel Forum
1 response
cmarzahn
Posts
35
Registration date
Wednesday 18 February 2015
Status
Member
Last seen
13 March 2015
7
20 Feb 2015 à 12:09
20 Feb 2015 à 12:09
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.
