Okay...I have a validation list set up to select names from a named range on
a different sheet. No problem there. What Id like to do it is reduce the
selection of names from the list once a selection has been made; but only for
a selected column!! For example, if the list is of €œnames€� and it has Tom,
Rob, and Fred in it, if the user selects Rob from the list, and if the list
is accessed again in the same column, Rob does not appear as an option to
select again. Alright.....I have a VB code that will automatically remove
the selected item from the drop-down validation list once it has been
selected once. However, the particular code Im using only allows each name
in the range to be used only once anywhere that the list is called. If
actually removes the selected reference from the original named list
permanently! This is my problem; I do not want the original named list
deleted. I want the validation list of choices to reduce. The reason is
that I want to use the named list in other places, with additional validation
lists (again to select from the original list). I could simply make x-number
of hidden copies of my original named list but that seems counterproductive.
Is there a way to modify the VB code that it just temporarily reduces the
visible selections until a new column is selected?

I have uploaded a copy of a sample file from which am working
(http://campus.pc.edu/~rarts/validation_test.xls). Basically, on the results
page, Id like to be able to select names from my list for a particular
column (Event #), switch columns (Events) and be able to pick from my
original list again until used up for that column, and etcetera....can anyone
help?