View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Osama Mira
 
Posts: n/a
Default 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