G Galsaba Jan 13, 2005 #1 How can I create a drop down list, while the list of item to be choose will be on a different worksheet? GalSaba
How can I create a drop down list, while the list of item to be choose will be on a different worksheet? GalSaba
D Debra Dalgleish Jan 13, 2005 #2 If you name the list on the other sheet, you can refer to it by name in the data validation dialog box. There are instructions here: http://www.contextures.com/xlDataVal01.html
If you name the list on the other sheet, you can refer to it by name in the data validation dialog box. There are instructions here: http://www.contextures.com/xlDataVal01.html
P Peo Sjoblom Jan 13, 2005 #3 Use a named range and then refer to that name, i.e. list is in A1:A20 sheet2 select the range and name it MyList, now in the other sheet select the cell, do data>validation>allow>list and use =MyList -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
Use a named range and then refer to that name, i.e. list is in A1:A20 sheet2 select the range and name it MyList, now in the other sheet select the cell, do data>validation>allow>list and use =MyList -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum)
D Dave Peterson Jan 13, 2005 #4 Define a Range Name. Debra Dalgleish has some nice instructions at: http://www.contextures.com/xlDataVal01.html#Name And if that list can grow, you could define a name that refers to a dynamic range. http://www.contextures.com/xlNames01.html#Dynamic
Define a Range Name. Debra Dalgleish has some nice instructions at: http://www.contextures.com/xlDataVal01.html#Name And if that list can grow, you could define a name that refers to a dynamic range. http://www.contextures.com/xlNames01.html#Dynamic
