In the source box for the List enter:

=sheetname!Jobs

Hope this helps.

Pete

On Nov 22, 2:31 pm, LittleAnn
wrote:
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



"Pete_UK" wrote:
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

On Nov 22, 12:36 pm, LittleAnn
wrote:
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??- Hide quoted text -

- Show quoted text -