Drop Down List - Source from another workbook
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 -
|