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?
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
column and if it finds the word "closed" move the entire row to another tab
in the spreadsheet?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
