How to remove items from a list as they are selected?

[Vack]

See attached workbook.

I have a several tabs all setup the same way.

Column B7:B:10 is a Postion. QB, RB, WR, TE....
Based off of the Position the next column will only show players in that position. C7:C10
These lists for QB, RB, WR.... are setup on a tab called SETTINGS.

What I would like to do is as a player is selected, that player no longer displays in the the list on any tab in the workbook.

Example: On the Tab labeled EB. I choose QB for my poisiton, Anderson,Derek for my Player. If I go to any other tab or any other place and pick QB I do not want to see Anderson,Derek in my QB list anymore.

[MarvinP]

Hi Vack,

In trying to understand your problem, it seems your data structure is too hard.

I'd put all players on a single sheet, in a single table.
Then I'd do a pivot table or something to eliminate players or positions that have already been selected. Having multiple sheets just makes the problem harder.

I hope this helps, although not what you wanted for an answer.

[JO505]

Here is a sheet that may give tou some ideas.

I got it from this forum a few years ago and have found it a very useful tool. I forgot who wrote the original so if someone remembers pleas give them credit.

Jim O