Cell dropdown using another Excel worksheet

[Mike]

I have a worksheet. I want one of the cells to have a dropdown list of
options that is populated via the values in another excel
workbook/worksheet(another file xls).

How can I do this?

Thanks,

Mike

 

[Frank Kabel]

Hi Mike
have a look at
http://www.contextures.com/xlDataVal05.html

 

[Tom Ogilvy]

insert =>Name => define

name: List1
Refersto: = '[Workbooks1.xls]Sheet1'!$A$1:$A$10

Click Add

then in the data validation

=List1

 

[Mike]

Danke sehr gut!

Thanks a lot.
This really helped.

Mike.