Maybe this is what you had in mind:

http://contextures.com/xlDataVal03.html

Biff

"dgraham" wrote in
message ...

Thanks Biff,

My example said 100 - 300 but the actual numbers will not be in
sequence ie.. 700 -755, then 800- 890, then 900 - 999 etc.. so I would
need to enter the number, validate it to an existing number held maybe
in another sheet, pop a message if the number was not valid and when
each correct number is entered those numbers are removed from the list
to avoid duplicate entries, I'm not sure if this is even possible in
Excel.

Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=529481