Adding a validation

[Amin]

hi there, i have 2 worksheets one is students Notes, the 2nd is
Student_List. how do i add data validation to a range in the Note sheet e.g,
A10:A20 and confine entris to the list of students from the student_list
sheet. thanks

 

[Jay Freedman]

hi there, i have 2 worksheets one is students Notes, the 2nd is
Student_List. how do i add data validation to a range in the Note sheet e.g,
A10:A20 and confine entris to the list of students from the student_list
sheet. thanks

This forum is for questions about Word. For Excel questions, please post in
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.
Since your problem is likely to involve a macro, you might try
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming.