2 paragraph of VBA code does not work correctly when being put into one worksheet

[xiaoaojh72]

Hello, good afternoon.

It would be appreciated if anyone can help me out.
See enclosed, I am trying to let the worksheet "Shipyard" to have two auto functions by two paragraphs of VBA Codes.
1. When editing the column 3, return the editing time at column 5.
2. When change the values in column 4 into "closed" or "class request", move this row into worksheet "Closed leads"

The two paragraphs of codes works separately, but does not work when they are put together.

Thanks in advance.

[arlu1201]

Try this code

Please Login or Register  to view this content.

[xiaoaojh72]

Thanks, arlu1201. But it looks not working properly. E.g. check "closed", run time error. Editing column 3 does not give editing time at column 5.

[arlu1201]

You have some other code in the 3rd worksheet hence it gives the error.

[xiaoaojh72]

HI, yes, It works well when delete the code in worksheet 3. But the prolem is that I need the code, which send the row back to worksheet "shipyard" when column 4 is changed to status other than "Closed" or "Class request". Any suggestions?

[xiaoaojh72]

Tried to use similar code on worksheet 3, it works fine now. Thanks so much!
I am wondering if I can give one more function to worksheet "shipyard" to sort all rows acc. to date sequence in column E.