Hello all!

I need some help on the following issue:

I have a named ranged defined in a worksheet.
I want members from several cells in other worksheet from the same
workbook to be able to recieve values from that list in the range, with
2 exceptions : empty cell or a string "rejected" per example - which
shouldn't be allowed values.
I'm using data validation, but I don't know how to make this happen or
if it's possible with this function.

Thanks in advance,
Chris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=486824