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