Drop Down List - Source from another workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Drop Down List Contains the List Header Row 1
Drop down List w/ Values Pop Automacailly when choose entry from l 8
Create Drop Down Box populated by a List 1
Formatting a drop down list 2
drop down list based on other drop down list pick 1
lost the drop down list (the validation still exist) 4
drop down lists 2

Back
Top