Create a macro in Excel which cuts a seleted row

**satyas462** · 10-14-2010, 09:30 AM

Hi I am trying to create a macro which cuts the selected row if it matches a certain criteria and has to paste it to a different sheet from the same workbook. Could Some please help me?

**JBeaucaire** · 10-14-2010, 11:48 AM

With so little information, I'll assume you're good at converting examples of code to your own needs:

Sub TestRow()

If Range("A" & Activecell.row) = "Yes" Then
   Rows(Activecell.Row).Cut
   Sheets("Sheet2").Activate
   Range("A" & Rows.Count).End(xlUp).Offset(1).Select
   Activesheet.Paste
End If

End Sub