IF Then statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have an if then statement that looks at a specific column and if it finds the word "closed" move the entire row to another tab in the spreadsheet?
 
try

for each c in columns(2)
x=sheets("sheet2").range("a65536").end(xlup).row+1
if ucase(c)="CLOSED" then c.entirerow cut sheets("sheet2").range("a" & x)
next

D-Day said:
Is it possible to have an if then statement that looks at a specific
Click to expand...
column and if it finds the word "closed" move the entire row to another tab
in the spreadsheet?
 
Back
Top