Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation
How can I create a drop down list, while the list of item to be choose will be
on a different worksheet? GalSaba |
#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 he http://www.contextures.com/xlDataVal01.html Galsaba wrote: How can I create a drop down list, while the list of item to be choose will be on a different worksheet? GalSaba -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#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 datavalidationallowlist and use =MyList -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Galsaba" wrote in message ... How can I create a drop down list, while the list of item to be choose will be on a different worksheet? GalSaba |
#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 Galsaba wrote: How can I create a drop down list, while the list of item to be choose will be on a different worksheet? GalSaba -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
data validation on sth else | Excel Worksheet Functions |