If the other workbook is open, you can use the technique shown he

http://www.contextures.com/xlDataVal05.html

MIKE0W wrote:
can I validate a list from another workbook?
example:
Celb b1
Validation:
use ci (column title) for list from another workbook




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html