Looking to create code that will look for the word "Complete" (will be the only word listed) in column M, Sheet1 and if it finds it, will cut the whole row and paste it at the bottom of data on Sheet2, named: Completed. Then delete the empty rows at are left after they have been cut.
2nd item: similar to above, but need it to look at column B, sheet1, need it to look for *Remove*, or *Change*, or *Relocation*, if it finds any of these words, (there will be other words also) then it will cut the whole row and paste to bottom of data on Sheet4, named: Review. Then delete the empty rows that are left after they have been cut. It can look at each of the 3 words in separate steps or code if needed.
Thanks
2nd item: similar to above, but need it to look at column B, sheet1, need it to look for *Remove*, or *Change*, or *Relocation*, if it finds any of these words, (there will be other words also) then it will cut the whole row and paste to bottom of data on Sheet4, named: Review. Then delete the empty rows that are left after they have been cut. It can look at each of the 3 words in separate steps or code if needed.
Thanks