In the source dialog enter =Jobs


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 06:31:00 -0800, 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??