I need a formula that will allow complete row information to be moved to another sheet upon status change.....

ex


name last name status etc etc

when changing from p to n under status the row should then be made visible on the other page