Require Help on updation of sheets

[tippu1019]

Hi Everyone !

My name is tippu, i need a simple solution to one of my excel problem. i have a excel workbook containing 3 sheets. the first sheet contains marks of all the 10 students with there roll numbers in test 1. the second sheet contains the marks obtained by the failed students in test 2. i need a updated data in sheet 3 of all the students, showing the marks obtained by the passed students in test 1 and also the updated marks obtained by the failed students in test 2. can anybody post a solution for this. please find a attached sample copy.