I have a list of items - for example list of names of students, and I
want the drop down list (for the data validation) to use that list.
But, How can I do that if I want to get the entries in the list in
only one sheet
(say sheet1) and have other sheet in the same workbook reference the
list from sheet sheet 1.
Thanks in advance.