Good day, the issue I am needing help with is the following.
I have a workbook with 5 sheets in it (new, delayed, in process, completed, and cancelled). In each of those sheets is a column named "Status" (all sheets are column F). What I want to do, is have all the sheets do something the same....when the status is changed from "new" to "delayed", I want the row to move from the "new" sheet to the "delayed" sheet. When column F is changed from "XXXXX" to "XXXXX" I want it to be automatically moved from the sheet is is on, to the sheet that corresponds with its status.
Can anyone help me with this?
Bookmarks