Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|