if a cell contains certain text, cut and paste to another sheet

M

Mili

Wanting to include this within a macro, so that if a particular cell has "N"
in the cell that the whole row will be cut and paste in to another sheet
within the workbook.
 
M

Myrna Larson

Since you're not specific WRT the cell location or the other sheet name...

If Range("A1").Value = "N" Then
Range("A1").EntireRow.Copy Worksheets("Sheet2").Range("A12")
End If
 
Top