ExcelBanter - Move Selected Rows To A Different Sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Move Selected Rows To A Different Sheet (https://www.excelbanter.com/excel-programming/366465-move-selected-rows-different-sheet.html)

cheeser83[_2_]

Move Selected Rows To A Different Sheet

I would like to select different rows on Sheet1 and then move them to
the next blank row on Sheet2. Can anyone please help?

Otto Moehrbach

Move Selected Rows To A Different Sheet

One way:
Sub MoveRows()
Selection.EntireRow.Copy
Sheets("Sheet2").Range("A" &
Rows.Count).End(xlUp).Offset(1).PasteSpecial
End Sub
Watch out for line wrapping. The line that starts with Sheets must end with
PasteSpecial.
HTH Otto
"cheeser83" wrote in message
ups.com...
I would like to select different rows on Sheet1 and then move them to
the next blank row on Sheet2. Can anyone please help?

cheeser83[_2_]

Move Selected Rows To A Different Sheet

Thank you for the help!!

Otto Moehrbach wrote:
One way:
Sub MoveRows()
Selection.EntireRow.Copy
Sheets("Sheet2").Range("A" &
Rows.Count).End(xlUp).Offset(1).PasteSpecial
End Sub
Watch out for line wrapping. The line that starts with Sheets must end with
PasteSpecial.
HTH Otto
"cheeser83" wrote in message
ups.com...
I would like to select different rows on Sheet1 and then move them to
the next blank row on Sheet2. Can anyone please help?

All times are GMT +1. The time now is 08:54 AM.