Data entry

alok - Dec 12, 2015 at 08:17 AM
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.