Excel-transfer from sheet1 to sheet2

Closed
Office Maven - Sep 23, 2011 at 04:35 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 23, 2011 at 04:59 PM
Hello,

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?
:(


Thanks


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 23, 2011 at 04:59 PM
May reasons

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
0