Data entry

[Closed]
Report
-
Hello,
i am working on two different excel sheets. in sheet 1 i have a similar types of entry suppose that students name of same student multiple times along with its details. In sheet 2 I want to apply the formula such that as i enter the student name in sheet 1 it should also get an entry on sheet 2 also but only one times.

Alok