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.
Microsoft Excel 2016
By: Matt Janes