About Us

cheeser83[_2_]

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

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_]

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?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Advanced Filter: How do you MOVE the selected rows...	ravif	Excel Worksheet Functions	3	June 29th 09 10:25 PM
move rows of data seperated in a sheet to a sheet with no separat	Lynn	Excel Worksheet Functions	5	December 22nd 06 03:18 AM
Create Macro - move selected rows to new spread sheet	chrisak	Excel Programming	1	May 24th 04 06:55 PM
Beginners' Question : How to move selected columns & rows to a two dimensional array	Erche DP	Excel Programming	3	July 18th 03 03:25 PM
Beginners' Question : How to move selected columns & rows to a two dimensional array	Erche	Excel Programming	4	July 18th 03 04:19 AM

Menu

About Us