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

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.

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


On Sun, 3 Apr 2005 19:41:01 -0700, "Mili"
wrote:

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.