automatic move row from sheet to another

[Guest]

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

 

[Dave Peterson]

First, I wouldn't do it.

I'd keep all my data on one worksheet and just apply data|filter|autofilter to
see what I wanted.

But if you want, you could record a macro when you filter by each value.

Then copy the visible rows to the new sheet

Then come back and delete those visible rows.

Same with Fail.

It isn't quite automatic. You'd run your macro on demand--but that may be safer
if you ever type the wrong value in the cell.