Moving old data to another sheet

[vanchi233]

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

[ilyaskazi_01]

This will require automation code through VBA and cannot be done with Excel formulas...






...