list valadition
 

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


--
MIKE0W
------------------------------------------------------------------------
MIKE0W's Profile: http://www.excelforum.com/member.php...o&userid=21465
View this thread: http://www.excelforum.com/showthread...hreadid=379001

Mike,
I will probably be corrected but I don't think you can validate a list
from another workbook.

You could paste a link of your list from book 2 to book 1 and use the
list in book1 as your validation list.

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=379001

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