I am using Sheet one as a list of materials I have ordered for our company. Once a material arrives, I change the "Status" column from "Open" to "Close." Normally once I have changed a cell, the row automatically goes to Sheet 2 where all the "Closed" orders are. About a week ago the "Closed" rows stopped transferring from Sheet 1 to Sheet 2. Can anyone help me to get these rows back on track?
may be you removed the macro or may be when you open the file, you are not enabling macro. may be other sheet is full may be there is change in the sheet layout. may be sheet is protected. Hard to tell you without looking at the code and the book or even knowing if there is any error or just simply does not work