Excel – Move Rows Automatically

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

Leave a Reply

Your email address will not be published. Required fields are marked *