list valadition

[MIKE0W]

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

 

[Debra Dalgleish]

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

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