Excel-transfer from sheet1 to sheet2 [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!