Vba to transfer automatically

[Revathi kannan]

Hi all,

Please assist me..

> I will change the status manually in column E. If my status reads ad "WIP" or "Completed" then automatically the specific line should be moved to "removed" sheet one by one.

> I want this to be done automatically (without running F5) whenever I change the status. Attached file for reference.

Thanks in advance.

[dangelor]

Placed in the Worksheets("Final") code module...

Please Login or Register  to view this content.