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...
--
To those who have helped in the past and those about to help, Thank You.
There is an intregeing element to Excel that has captured me and that
stimulates my every remaining brain cell. Awesome