DropDowns - allowing each value to be used once

  • Thread starter Thread starter Football Express
  • Start date Start date
F

Football Express

In a 17 worksheet workbook I need to allow one of 32 possible dropdown
entries to be used but once. I have the custom validation box with the 32
entries in worksheet 1 but can not figure out how to eliminate the the
already used entry in worksheet 2, the used values in worksheets 1 and 2 to
not show up in the dropdown or worksheet 3, the used entries in worksheets 1,
2, and 3 not to show up in worksheet 4 and so on?
Any help appriciated.
PS: yup it's me again as football season draws near...
 
If we assume that you use the SAME dropdown list for all, you could have a
worksheet change event macro delete the selection. Biff's suggestion may be
better.
 
I think i would be tempted to use a combobox from the control toolbox then
give it a sub on click to move items from the list fill range

Don Guillett said:
If we assume that you use the SAME dropdown list for all, you could have a
worksheet change event macro delete the selection. Biff's suggestion may be
better.
Click to expand...
 
Back
Top