moving a whole row to bottom of list if cell has Z in it automatically without manually running

[Daleksec93]

Hi Experts!

I have had a go at this myself and have only been able to do make this work when i initially put the code in. Does not continue to work there after.

I am trying to move a row to the bottom of my list automatically if I type "Z" in the "Job completed?" Column (A3-E218.)

I need this to happen instantly after typing "Z".

Please let me know if there is any other information you will need to be able to help me with this.

Thank you!