I have a workbook that has 4 sheets. What I would like to do is that every time the word "completed" is entered in column, the entire row will be automatically removed and moved to sheet titled "Completed." What I have been doing now is cutting and pasting the rows manually and I want to avoid doing that.
Here is some information....
I have a sheet called "Appeals-Updated" that has columns from A thru M....so when I enter "completed" on column M the entire row with entered information will be moved.