Need macro to move row to another worksheet within the workbook

[mmccra2858]

Help!
I'm trying to create a macro to cut a row from one worksheet and move it to an archive work sheet.
I've used macro record to cut and past but when I cut and past another row, it wipes out the first one I archived. This is what I have so far

Sub archive()
'
' archive Macro
'
' Keyboard Shortcut: Ctrl+Shift+A
'
Rows("2:2").Select
Selection.Cut
Sheets("Archive").Select
Rows("2:2").Select
ActiveSheet.Paste
Rows("3:3").Select
Sheets("work orders").Select
Selection.Delete Shift:=xlUp
End Sub

[RaulRodriguez]

Try this

Please Login or Register  to view this content.

[mmccra2858]

I tried to get your example to work, maybe I'm doing omething wrong, kept getting an error.
I'm attaching an example of my spreadsheet, the macro I recorded soes what I want up to a point. It takes information from one page and puts it in another but when I repeat the process itt erases the previous line. All I want to do is add in code to move information to the archive adding the lines under the last copied. By the way, thank you for your help.

Matt

[jraj1106]

Hi

What is the condition to cut and paste rows...

[mmccra2858]

yes, I am cutting the row from one sheet and trying to archive it in another. I used macro recorder, I'm looking for a way to put the next cut row under the one that was archived. Right now my macro puts the new row in place of the old on on the archive sheet.