Drop Down List - Source from another workbook

L

LittleAnn

I am working on a worksheet that will have a drop down list. But the list I
need the list to come from is in another workbook that has 900 entries in it,
whats the fastest way to do this??
 
P

Pete_UK

Define a named range to cover the data in your source sheet. Then in
Data | Validation on the cell where you want the drop-down to appear
select List and enter the name as the source.

Hope this helps.

Pete
 
L

LittleAnn

I did all this previously but and named the cell range "Jobs" and the only
thing that comes up on the drop down list is the word "Jobs", what might I be
doing wrong
 
X

xrelanon

Firstly you should not be using a drop down list pointing to a list of 900
line items.

Rather, use an input cell that uses VLOOKUP to find the correct row and
column you are interested in using in your calculations (use exact lookup if
you want to restrict specific return values). Of course, your 1st column in
the 900 line item list will have to be sorted in some manner. I would put the
list in the same workbook as your drop down list. Finally, to restrict
erroneous user inputs, use Data Validation other than a Pick List.
 
Top