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.
|