automatic move row from sheet to another
Hi,
What should I do to make the following in excel
I have three sheets which are Students, Homework success, and Homework fail.
in Students sheet I have the following columns: student ID, Student Name,
Student e-mail, and homework status.
I am working on Student sheet and i have list of students information but in
Homework status there is nothing. I need when I write DONE on homework status
automaticly move (not copy) this row information to onther sheet which is
Homework success, and when i write FAIL on homework status automaticly move
(not copy) to homework fail sheet.
Is it posible in excel sheet???? and how
|