Help with data validation question

[Legacy 420921]

Get file below is link
https://1drv.ms/u/s!AnJwxxiz0Ezpg8YaJybiTFXDUaN6tQ


[FONT=&quot]I have sheet call BYE WEEKS

I have data validation with no repeat name after you pick team will not be there on rest data validation list.

when you pick a team list start at end of list how i fix this that drop list. the start at top list also how take out empty from after pick team put blank.

I want you pick teams will not anything only names that not been pick yet[/FONT]
[FONT=&quot]The two worksheet are open look at both

Thomas[/FONT]

 

[Taul]

Hi,
If I have understood correctly, you need "Hide Used items in a drop down list"
There is a full explanation here along with a downloadable file to play with:-

https://www.contextures.com/xlDataVal03.html

Scroll to the bottom to access the downloadable file.

cheers
Paul