copy entire row to another sheet conditionally

hi every 1
here is my problem
sheet1 is "main register" . sheet2 is "expelled" and sheet3 is "active stu" when any cell in col E is = "expelled" i want the entire row to be copied to sheet2 AND also if i change a col E cell (lets say E12) from "expelled" to "active stu" it should remove the row from sheet2 and be copied it to sheet3. i prefer it without any button. just to be automatic.

pls instruct me in little detail. i am not very familar with VB.

hi sada ... this can be done fairly easily ... post a sample of your book showing how your sheets are set up & I'll take a look for you ..

Here you go:

Please Login or Register  to view this content.

Code is also in the attached workbook (Excel 2003) and is linked to the button in the main sheet. Hope that helps.