Create the Validation List on one sheet, but use a formula that watches
the Validation Cells on the other sheet and hides the numbers as they
become chosen, so they no longer appear in the validation list.

Attached is a sheet showing this scenario.


+-------------------------------------------------------------------+
|Filename: ReducingValidationList.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=59|
+-------------------------------------------------------------------+

--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46886