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.

Hi,

Am Sat, 10 Sep 2011 06:43:09 -0700 (PDT) schrieb Subodh:

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.

in this case you have to name the list and then use that name as source
for the data validation.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Give the list a name.

2003...........InsertNameDefine..........name it MyList

When creating DV dropdown on any sheet source will be =MyList


Gord Dibben Microsoft Excel MVP

On Sat, 10 Sep 2011 06:43:09 -0700 (PDT), Subodh
wrote:

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.